Spamassassin cache in mysql - feature request
ecasarero at gmail.com
Wed Mar 18 13:01:38 GMT 2009
2009/3/18 Matt <spamlists at coders.co.uk>:
> 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
Here are the results:
(2 MS servers) 34 matches, one cache had 820 records and the other 548.
i just don't see the benefit, however somebody with a different
scenario may have a different view...
my 5 cents.
> MailScanner mailing list
> mailscanner at lists.mailscanner.info
> Before posting, read http://wiki.mailscanner.info/posting
> Support MailScanner development - buy the book off the website!
More information about the MailScanner