Bob Pierce 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. > >
Corruption? Well, that would be a bug then, can you please provide some more specifics? Open a bugzilla bug please. >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? > > sa-learn --force-expire >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. > > Don't expire things manually. Michael
signature.asc
Description: OpenPGP digital signature