Spamassassin cache in mysql - feature request

[Eduardo Casarero]

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
> http://lists.mailscanner.info/mailman/listinfo/mailscanner
>
> Before posting, read http://wiki.mailscanner.info/posting
>
> Support MailScanner development - buy the book off the website!
>