Paolo Cravero as2594 wrote:
Gents,
here's the result.
OPTIMIZE TABLE msgs, msgrcpt, maddr, quarantine;
The man page http://dev.mysql.com/doc/refman/4.1/en/optimize-table.html
does not mention anything about disk space requirements (it is in a
comment instead) or slow-query behavior.
I let the nightly cleanup script run without OPTIMIZE TABLE at the end.
MySQL disk usage did NOT double, so be careful when running the OPTIMIZE
TABLE statement: you need as much free disk as your quarantine DB (minus
deleted items).
OTOH disk usage did not decrease of the usual 1-2%, so now I'll monitor
"SHOW TABLE STATUS" output for "InnoDB free" values. The DB engine
should reuse free space.
I confirm that OPTIMIZE TABLE is NOT logged to MySQL slow-queries.log.
Paolo
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
