rocsca, > > amavisd-new on the other hand uses persistent connection to SQL on its > > own SQL lookups and logging/quarantining to SQL, one connection per > > child process. > > How I have to do to migrate amavisd-new versus SQL database? Are there > effective improvements?
You don't have much choice: Bayes and AWL are handled entirely by SA, so you must use its mechanism of accessing SQL. The only choice is with white/blacklisting, where either amavisd-new or SA method of SQL w/b-lists can be used (but they are somewhat different). I should have added that newer versions of SA offer a dedicated Bayes plugin for more effectively using MySQL, and another for PostgreSQL, as opposed to a previous general-purpose interface to SQL. >From spamassassin/sql/README.bayes: There is also a MySQL specific storage driver available to provides a small boost in performance. It requires version 4.1 or above of the MySQL database software to work properly. In addition, it provides rollback on error functionality if you create your bayes database table using the InnoDB storage engine (ie s/MyISAM/InnoDB/ on the bayes_mysql.sql file). WARNING: Using this module with a version of MySQL < 4.1 could have unexpected results. To use the MySQL 4.1+ specific module set your bayes_store_module directive accordingly: bayes_store_module Mail::SpamAssassin::BayesStore::MySQL > > You should ask on the SA list. How many child processess are you > > running? > > set-variable = max_connection=200 I mean amavisd child processes ($max_servers). Mark All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642 _______________________________________________ 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/
