Spamassassin cache in mysql - feature request

Matt spamlists at
Wed Mar 18 11:21:53 GMT 2009

Eduardo Casarero wrote:
> I did some research in 1 of my servers, today i've procesed 8505
> emails, with 338 cache hits. How  can we measure if sharnig caches
> improves (a lot, a little, nothing) cache hits? (there is another
> server next to it) Obviously without much development so we can test
> if having a mysql server improves or not the scenario.

On each box you need to do

sqlite3 /var/spool/MailScanner/incoming/SpamAssassin.cache.db "select 
md5 from cache;" > /tmp/cachehashes.servername

move the files on to one box

cat /tmp/cachehashes.serv1 /tmp/cachehashes.serv2 | sort | uniq -c | 
sort -n | grep -v " 1 "

Any lines outputted will be the same hash on multiple servers

More information about the MailScanner mailing list