Paul J Stevens wrote: > > > > [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. > >
1. Is the dbmail_messageblks table cant be optimized? 2. What would u suggest the mysql.cnf config should be like for 2000+ users & at least 1000 incoming mails per day? I tried asking in another thread, but nobody seems to have the answer.... if anyone do have an answer, please help.. thanx ;) -- View this message in context: http://old.nabble.com/dbmail---mysql-..-tp7810337p26772809.html Sent from the dbmail users mailing list archive at Nabble.com. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
