Rocco, > I have ported naive bayes spam DB -> MySQL. I can't see any improvement at > the moment... Should the CPU works less then when I use naive db (I noted > the bayes_seen file in home dir of amavis user was about 100 MB and similar > dim has the auto-whitelist file, so I think that thi can be an high load > for the CPU to examine every time that one message needs to be scanned - > also my system send/receive about 110.000 message per day)? > > Moreover, It seems to me that is not possible to share one DB for two SA.. > infact I feel that one time taht I migrate the second SA bayes db file, > this overwrite the data of the first SA bayes db file... It this possible?
Like Martin is saying, you can have multiple amavisd-new instances share the same SQL Bayes database. This is actually the same as is already happening when you have more than one amavisd child process. With SA 3.1 there comes a specialized MySQL pluging for Bayes. It takes advantage of the transactional capabilities of newer MySQL InnoDB storage engine, which is somewhat more reliable when confronted with lots of parallel clients like in your case (avoids a need for an occasional manual Bayes database REPAIR). See SA docs on how to enable it. Compared to bdb storage for Bayes, the SQL is a little faster in normal operation, but is *substantially* faster doing opportunistic auto-expiry, which is a common problem that amavisd-new users are experiencing when their Bayes database grows large. Mark ------------------------------------------------------- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl _______________________________________________ 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/
