[EMAIL PROTECTED] wrote: > -rw-rw---- 1 mysql4 mysql4 23995613184 Oct 20 11:47 dbmail_messageblks.ibd
he! are those innodb table spaces? Been reading about them, but haven't used them yet.. > 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. I'm open to suggestions and ideas here. I've been having this very same problem. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
