On Tue, 09 Mar 2010 10:24:19 -0800 Curtis MacDuff <curtis.macd...@pspinc.com> wrote:
> My Bayesian filter keeps getting screwed up and causing mail flow to > stop. The problem seems to be expiring tokens out of the database. My > expiry setting is set to 200,000. I've tried many different settings > for this but they all seem to behave about the same. Auto learn is > also on. > > When this happens the mysqld service eats up loads of CPU and stops > responding to requests from Amavisd-new. Since Amavisd-new is > expecting information from mysqld it stops the mail flow. I attached > the output from the 'show processlist' command, one query seems to > have been ran for 12hours without stopping. Try running sa-learn --force-expire from cron and turn-off auto-expiry