Thanks Mark, I didn't know about this feautures of SA 3.1. Infact I created MyISAM tables... so now I have to:
1) migrate bayes db on flat files again 2) drop the db 3) create the db with InnoDB storage engine 4) migrate db from flat files to new DB :( PS: If I decide to mantain the MyISAM storage engine, how I have to 'repair' the bayes db manually? Thanks, rocsca ----- Original Message ----- From: "Mark Martinec" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, October 20, 2005 12:53 AM Subject: Re: [AMaViS-user] About SA... > 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/ ------------------------------------------------------- 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/
