> -----Messaggio originale----- > Da: Chris St. Pierre [mailto:[EMAIL PROTECTED] > Inviato: giovedì 8 marzo 2007 23.33 > A: users@spamassassin.apache.org > Oggetto: Make Bayes more efficient? > > We're sharing our Bayesian database (MySQL) between two MX nodes and > the database server has hit a wall. It's underpowered and is no > longer able to keep up with the I/O demands of our two MXes. During > the day, uptime on the machine plateaus at about 5-7, and iowait > percentage rides at about 70-90%. Our mail queue and time-to-scan > skyrocket. Luckily, we've been able to catch up at night thus far, > but it's still not fun having 500 messages enqueued from 8-5 daily. > > Until I get our DB box replaced this summer, is there anything I can > do to make things work more efficiently? Options I'm currently aware > of are: > > 1. Stop doing Bayesian filtering. > > 2. Turn off autolearn. > > 3. Throw more hardware at the problem (which is the plan -- > eventually...) > > I ran a manual ''sa-learn --force-expire'', but that didn't have any > effect. > > Database sizes (in rows) are as follows: > > bayes_expire: 219 > bayes_global_vars: 1 > bayes_seen: 670102 > bayes_token: 801496 > bayes_vars: 117 > > To give an idea of the magnitude of this problem: it took 34 minutes > and 19 seconds to count the bayes_seen rows. > > Mail volume per MX is roughly 40K messages per day, <10K of which ever > make it to SpamAssassin. > > Ideas? Thanks!
Sorry, my English is probably not so good to understand the correct meaning of the "ever make it to SpamAssassin". If you mean that only 10K messages do reach a mailbox and the others are discarded by SA, you could attempt reducing the flux by adopting some greylisting technique. Thanks to it, I decreased a lot the amount of messages that reach amavis (and thereby SA). You may even not need an hw upgrade if this solution works enough also to you. Giampaolo > > Chris St. Pierre > Unix Systems Administrator > Nebraska Wesleyan University > ---------------------------- > Never send mail to [EMAIL PROTECTED] > > > Chris St. Pierre > Unix Systems Administrator > Nebraska Wesleyan University > 402.465.7549 > ---------------------------- > Never send mail to [EMAIL PROTECTED]
