Hello Michael, Monday, July 25, 2011, 9:30:11 AM, you wrote:
> On 7/25/11 10:24 AM, Jason Ede wrote: >> >> We’ve 2 reasonably powerful mail servers handling incoming email and >> sharing the load. We’ve moved to a single bayes database (to make >> training easier) and its stored in mariadb and all of the bayes tables >> are innodb >> >> # mysql -V >> >> mysql Ver 14.16 Distrib 5.2.7-MariaDB, for unknown-linux-gnu (x86_64) >> using readline 5.1 >> >> The bayes settings are… >> >> bayes_store_module Mail::SpamAssassin::BayesStore::MySQL >> >> bayes_sql_dsn DBI:mysql:bayes:localhost >> >> bayes_sql_username sa_user >> >> bayes_sql_password ******** >> >> bayes_sql_override_username root >> >> bayes_expiry_max_db_size 1000000 >> > missing this: > bayes_auto_expire 0 > and only run the 'sa-learn –force-expire' late at night, when no one is > doing anything. Should this even be an issue if one is using an SQL backend and has it configured to handle the extra processing? The OP is using MySQL as the backend. I've had MySQL configured for several years and have never had issues with the default 'bayes_auto_expire' left at its default being turned on using a per-user configuration. I can provide my my.cnf MySQL config. It is based off a server using 12 gig of memory. -- Best regards, Duane mailto:du...@duanemail.org
