Hi all! After 1-2 months testing dbmail I have installed it on our main mail server. Now everything is ALMOST fine, but some questions still not resolved. The first question about dbmail-util. If we run dbmail-util -arf our database starts performing OPTIMIZE TABLE procedure. Everything Ok, except "OPTIMIZE TABLE dbmail_messageblks" query. Here is listing of dbmail directory on MySQL: total 23790736 -rw-rw---- 1 mysql4 mysql4 65 Aug 15 21:51 db.opt -rw-rw---- 1 mysql4 mysql4 8998 Oct 6 08:11 dbmail_acl.frm -rw-rw---- 1 mysql4 mysql4 131072 Oct 6 08:16 dbmail_acl.ibd -rw-rw---- 1 mysql4 mysql4 8690 Oct 20 10:56 dbmail_aliases.frm -rw-rw---- 1 mysql4 mysql4 131072 Oct 20 10:56 dbmail_aliases.ibd -rw-rw---- 1 mysql4 mysql4 8620 Oct 6 08:11 dbmail_auto_notifications.frm -rw-rw---- 1 mysql4 mysql4 114688 Oct 6 08:16 dbmail_auto_notifications.ibd -rw-rw---- 1 mysql4 mysql4 8612 Oct 6 08:11 dbmail_auto_replies.frm -rw-rw---- 1 mysql4 mysql4 114688 Oct 6 08:16 dbmail_auto_replies.ibd -rw-rw---- 1 mysql4 mysql4 9042 Oct 20 10:56 dbmail_mailboxes.frm -rw-rw---- 1 mysql4 mysql4 524288 Oct 20 10:56 dbmail_mailboxes.ibd -rw-rw---- 1 mysql4 mysql4 8754 Oct 6 08:07 dbmail_messageblks.frm -rw-rw---- 1 mysql4 mysql4 23995613184 Oct 20 11:47 dbmail_messageblks.ibd -rw-rw---- 1 mysql4 mysql4 9012 Oct 20 10:56 dbmail_messages.frm -rw-rw---- 1 mysql4 mysql4 285212672 Oct 20 11:48 dbmail_messages.ibd -rw-rw---- 1 mysql4 mysql4 8630 Oct 6 08:11 dbmail_pbsp.frm -rw-rw---- 1 mysql4 mysql4 131072 Oct 6 08:16 dbmail_pbsp.ibd -rw-rw---- 1 mysql4 mysql4 8684 Oct 20 10:59 dbmail_physmessage.frm -rw-rw---- 1 mysql4 mysql4 67108864 Oct 20 11:46 dbmail_physmessage.ibd -rw-rw---- 1 mysql4 mysql4 8608 Oct 6 08:11 dbmail_subscription.frm -rw-rw---- 1 mysql4 mysql4 131072 Oct 13 12:56 dbmail_subscription.ibd -rw-rw---- 1 mysql4 mysql4 8934 Oct 20 10:55 dbmail_users.frm -rw-rw---- 1 mysql4 mysql4 393216 Oct 20 11:46 dbmail_users.ibd
Table "dbmail_messageblks" has almost 24Gb size (we have about 45000 emails each day!). So when "OPTIMIZE TABLE dbmail_messageblks" starts Mysql sets locking on this table and write operations delays while optimize process runnig. It has a very long time to parse 25Gb of data (MySQL creates temporary files of the same size to rebuild table) and all clients who fetch mail with pop3 or imap get time out error. In this state our MX server (that push mail in MySQL server through dbmail-smtp utility) increases number of processes in many times... If anybody now how to do optimize MySQL tables in such hard terms - please answer.
