Paolo, > My nightly script ends with > OPTIMIZE TABLE msgs, msgrcpt, maddr, quarantine; > which apparently is NOT logged to the slow-queries MySQL log in case it > runs longer than the threshold (= 3 sec, query goes on for 35 minutes).
I would leave out the OPTIMIZE TABLE from daily cron runs, and perhaps only do it only once in a while, perhaps weekly. ------------------------------------------------------- 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ 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/