Hi,
We manage a not little mail system for our university (~100k messages
per day). In includes:
- a few front-ends (Courier SMTP/IMAP/POP3/webmail/maildrop) which
connect to random Spamassassin host via spamc utility,
- a cluster of a few servers with Spamassassin (3.2.1-1ubuntu1),
- another one server with MySQL (5.0.38-0ubuntu1) to store Bayes
and FuzzyOcr database, etc.
The results is that spam was killing our MySQL database, because we
had ~50k queries per minute with INSERTs and UPDATEs of a many tokens.
The only one solution was to disable Bayes.
Have you tried this on your SA servers?
http://wiki.apache.org/spamassassin/DBIPlugin
AFAIK spawning many connections to mysql servers causes quite a big load
on them.
--
Pawel Sasin
WIRTUALNA POLSKA SA, ul. Traugutta 115c, 80-226 Gdansk; NIP: 957-07-51-216;
Sad Rejonowy Gdansk-Polnoc KRS 0000068548, kapital zakladowy 62.880.024 zlotych (w calosci wplacony)
