> -----Original Message----- > From: Chris St. Pierre [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 08, 2007 5:33 PM > To: users@spamassassin.apache.org > Subject: Make Bayes more efficient? > > We're sharing our Bayesian database (MySQL) between two MX > nodes and the database server has hit a wall. It's
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? Also, did someone let you know that while Innodb is required for stability in bayes, it WILL slow down writes? 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 You also said you are sharing a sql db for bayes between mx's. 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) -- Michael Scheidell, CTO SECNAP Network Security Corporation HackerTrap Managed IPS: www.secnap.com/services Privacy and Security Training: www.secnap.com/training ----------------------------------------------------------------- This email has been scanned and certified safe by SpammerTrap(tm) For Information please see http://www.spammertrap.com -----------------------------------------------------------------
