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? Michael
signature.asc
Description: OpenPGP digital signature
