Am 23.02.2016 um 10:40 schrieb Andrea Brancatelli:
Probably you should do an optimize table on dbmail_messages and such.Consider it will take quite long time, and, even if it's not blocking, it will slow down the mysql server pretty much. Furthermore take in consideration that on "first" run of dbmail-util the mail il flagged for deletion and on the subsequent run is actually deleted. In general it's pretty normal to have some spurious datas in the DB. Last consideration, if you're very concerned about disk space take in consideration enabling InnoDB Barracuda and do an ALTER TABLE Engine=InnoDB ROW_FORMAT=COMPRESSED; on the bigger tables - they will shrink down a lot
both only works with non-default "innodb_file_per_table = 1" setting, otherwise all data is in the global table space
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
