Re: [AMaViS-user] Disk usage UP during nightly cleanup

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/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/