On 8/10/05, Bob Pierce <[EMAIL PROTECTED]> wrote: > We're running spamassassin with a MySQL bayes database that is shared by > 4 scanning servers. > > We had been initially using the bayes auto expire option in local.cf, > but found that this occasionally caused table corruption. > > With auto expire turned off, everything works fine, but after a while > our bayes database gets huge (~9 million records in bayes_token). > > Does anybody have a good tip on how to manually expire some of those > records from the database?
As was already said, use sa-learn --force-expire to expire the Bayes database. On our busy servers I set this up so it's run from cron every night at 4AM. Gives pretty good results. Cheers, BQ
