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
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/