MailScanner + Bayes on SQL

[Kai Schaetzl]

Dhawal Doshy wrote on Tue, 16 May 2006 17:45:57 +0530:

> Yes, but disk is cheap.. comparing MySQL (innodb) with DBM: scanning and 
> expiry are way faster, forgets are slower and learning is more or less 
> as fast/slow as for DBM. 

Yeah, that's why I wanted to change. 

> See these for more details.. 
> http://wiki.apache.org/spamassassin/BayesBenchmark 
> http://wiki.apache.org/spamassassin/BayesBenchmarkResults 

> Plus SQL will let you share Bayes across multiple front-end MX servers 
> and permission errors are a thing of the past..

Sharing is only feasible for a few of my servers, but, yes, it's a bonus if 
you need it.

As it seems you don't need the bayes_sql_override_username when you backup. 
It's only needed when you read it in again. I used the backup.txt I had 
done on another machine (with Bayes on dbm) without 
bayes_sql_override_username and then restored it on the machine with the 
testing setup and bayes_sql_override_username set. This took quite long 
since the machine isn't the fastest and it were around 2 million tokens. 
Bayes works.

Kai

-- 
Kai Schätzl, Berlin, Germany
Get your web at Conactive Internet Services: http://www.conactive.com