On Sat, 17 Mar 2007, Michael Scheidell wrote:
I didn't see this answer yet, but, you show the sa-learn --force-expire,are you using bayes_auto_expire 0 in local.cf?
No, I'm not.
Also, did someone let you know that while Innodb is required for stability in bayes, it WILL slow down writes?
I did not know that; we are using InnoDB. Luckily, I've been able to tune a sufficient amount of performance out of it.
Also, in local.cf, you use the enhanced sql modules? user_awl_dsn DBI:mysql:mail:localhost bayes_sql_dsn DBI:mysql:mail:localhost bayes_store_module Mail::SpamAssassin::BayesStore::MySQL And: auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
I currently only have Bayes stuff in MySQL, not AWL, but yes, I am using the enhanced modules.
Ever think of making the secondary MX have a separate READ ONLY bayes DB? Feed it from the primary? (you don't want a secondary MX to have a different bayes from the primary since it will have a VERY jaded view of the world. Spammers go for the secondary first)
We don't have a secondary MX. Our MySQL database is shared between two MX nodes of equal priority. Chris St. Pierre Unix Systems Administrator Nebraska Wesleyan University ---------------------------- Never send mail to [EMAIL PROTECTED]
