Re: Assistance with DB (mysql) size optimisation

Further to this - sorry i just looked at the archive and saw the "[Dbmail] database overhead” subject that has been discussed just recently… 

We have "innodb_file_per_table = 1”, so am i correct that i should run "optimize table” on all the tables, then also enable InnoDB Barracuda and do an ALTER TABLE  Engine=InnoDB ROW_FORMAT=COMPRESSED?

Thanks

Simon


On 3 March 2016 at 9:30:50 AM, Simon Buchanan ([email protected]) wrote:

Hi All,

We are running dbmail 2.2.18 for some legacy clients, the database is a debian default 5.1.73. We have around 260 mailboxes on this server that (when dbmail-export’ed) comprise of 72G of data, or approx 280MB per mailbox on average. We are running "/usr/local/sbin/dbmail-util -ay” every morning at 3am.

The problem we have is that the mysql data store is around 680G with the dbmail_messageblks.ibd file being the culprit at 654G. 

Is there any way to claw back this space?

Thanks!

Simon

_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail