Dave, > > 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)
The BayesStore::MySQL module is able to take advantage of some MySQL and InnoDB features that are not available with a generic SQL BayesStore. Consequently, things work more reliably (using transactions, database does not need occasional/unpredictable repairs), and possibly a bit faster. Mark ------------------------------------------------------------------------------ _______________________________________________ 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/
