Michael Parker wrote:
Cami wrote:
SQL simply doesnt scale very well for bayes. We have a serverfarm of
12 spamassassin servers and storing bayes in SQL. We see on average
about 4000 queries per second. The MySQL server has been optimized
to hell and back and is running on high-end hardware,but just simply
doesnt scale as more and more mail begins to roll in.
I'd be interested in your setup (MySQL and SA). I have no problems
getting 4200+ queries per second on a single processor machine, with
spamd running on the same box. It's not even sweating that hard. When
you are at peak what is your average scantime per msg?
Well.. As for setup, we're using amavisd-new which provides more
functionality than spamc/spamd (thus producing more sql queries).
As for average scantime per msg, no idea since i dont log that.
Hardware wise: Dell PowerEdge 2650, Dual 3.06GHz, 6gigs of ram,
5x32K RPM disks in Raid 10/1+0..
Cami
