'sa-learn --force-expire' is your friend. Just run it on one of the
servers periodically. I run it once every four hours.
Bob Pierce thought no one was listening and belted out:
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?
Is ut as simple as deleting all records in the bayes_token table that
have an atime older than a specified time?
Is there any other logic that should come into play when expiring the
bayes tables?
Any tips or suggestions appreciated.
Thanks,
Bob Pierce
