On 19-03-15 21:16, Simon wrote:
What im trying to understand is why is the SUM of curmail_size is
approx 110GB, yet the database size (even dump'ed) is 400GB. Surely
dbmail does not have that much overhead in its database?
As Reindl stated, why still use dbmail 2.2 without the
single-instance-storage and a outdated mysql 5.1?
In our setup we get curmail size well below the actual disk usage
because people tend to email each other the same signature image over
and over, and in the new dbmail these are stored only once.
Still, 400G is a little too much for me compaired to the 110G curmail
size. My guess is that your sql dump files are very verbose (use a
statement per row, thus containing a lot of SQL language overhead) or
you should make sure your dbmail-util (see
http://linux.die.net/man/8/dbmail-util ) cron job is running.
Have you ran innodb table optimization yet? What is the new size?
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
