On Apr 22, 2010, at 10:29 AM, Mark Martinec wrote: >> I'm using an older version of amavisd-new now, but am currently in >> the >> process of upgrading. In the interim, I'd like to make some >> performance improvements to ease the load until I can upgrade. > > Move Bayes and AWL databases to SQL, if you haven't already done so. > See sql/bayes_mysql.sql and sql/README.bayes in the SpamAssassin > package. > Using InnoDB and Mail::SpamAssassin::BayesStore::MySQL is a must > (i.e. do not use Mail::SpamAssassin::BayesStore::SQL as a > bayes_store_module).
Hmm, this is news to me...What's the advantage of InnoDB over MyISAM for these tables? Does the same advice apply to MySQL-based quarantine tables? Also, why BayesStore::MySQL over BayesStore::SQL? (just curious) -Dave > -- Dave McGuire Port Charlotte, FL ------------------------------------------------------------------------------ _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/