On 02/03/16 20:30, Simon Buchanan 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?
I would try restoring a dump of dbmail to an empty database with perhaps 100GB innodb space allocated (plus auto expand option). Our setup is quite similar in scale to yours dbmail 2.2.18, mysql 5.1.63, ~ 200 user accounts and we run the same nightly dbmail-util options. Our mysql install is standalone (on CentOS) rather than distro package but it seems unlikely this should make a difference. Our total innodb space usage is around 63GB (2 files, not file per table). A dump of the database uncompressed is 54GB. This is consistent with the 20% space overhead in the discussion thread you referenced. I think when we last did a dump and restore around a 15 months back we gained back ~ 20GB, but if you've been running without for many years and with your current factor of 9 overhead you may gain much more. _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
