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

Paolo Cravero as2594 wrote:

A self-reply with a probably correct answer.

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).

The man page http://dev.mysql.com/doc/refman/4.1/...ize-table.html
does not mention anything about disk space requirements (it is in a
comment instead) or slow-query behavior.

I've commented out that line now, and will see tomorrow (European)
morning what happened during the night.

Will report here the effect, and in case ask Mark to add a comment to
amavisd-new docs.

Paolo

--
| QRPp-I #707 + www.paolocravero.tk + I QRP #476 |
| SpamAssassin-based email antispam/antivirus solutions |
\ Italian/English-to/from-Croatian translations /
\ Skype: pcravero /


-------------------------------------------------------
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/