Spamassassin cache in mysql - feature request

[Matt]

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