Re: database overhead

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

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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iEYEARECAAYFAlbMKtIACgkQhmBjz394AnlSXQCfSpumjKpK9Q37mhtxHN5JBF1W
iDIAnA51HBCMhtQrtqrPPpUxizJ9MqNb
=MkYh
-----END PGP SIGNATURE-----