Hi.
Running here amavisd-new 2.3.3 with quarantine to MySQL 4.1.14 InnoDB
under Linux. Postfix, SA and ClamAV complete the setup.
Every night the quarantine cleanup script is run. A du -ks of MySQL
quarantine DB says 13.5GB are occupied.
During the nightly cleanup I see from MRTG that the disk
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
Michael,
I want to move an existing amavisd-new/SA installation to use
msql for bayes.
Don't you hate working on something for a day, posting a question and 5
mins later finally figuring it out?
Might put this in amavisd- FAQ for sql readme
...
Also needs:
bayes_sql_dsn
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