Re: SA MySQL DB maintenance
On 2018-07-18 01:11, Giovanni Bechis wrote: Txrep does not have autocleaning support, bayes have it if auto_bayes_expire is set. Giovanni I have looked into this here: https://spamassassin.apache.org/full/3.1.x/doc/sa-learn.html#expiration Our Bayes DB is over 5Gb which seems at odds with the auto purge figures mentioned at the above link. Even running "sa-learn --auto-expire" does not impact the size. -- Further to my above post, running "sa-learn --auto-expire" with "bayes_auto_expire 0" set in the config produces a different result, namely the database is now down to a few 10's of Mb. I am taking the advice provided here and running this command as a cronjob. Many thanks. Michael
Re: SA MySQL DB maintenance
On 2018-07-18 01:11, Giovanni Bechis wrote: Txrep does not have autocleaning support, bayes have it if auto_bayes_expire is set. Giovanni Hi Giovanni, I have looked into this here: https://spamassassin.apache.org/full/3.1.x/doc/sa-learn.html#expiration Our Bayes DB is over 5Gb which seems at odds with the auto purge figures mentioned at the above link. Even running "sa-learn --auto-expire" does not impact the size. Michael
Re: SA MySQL DB maintenance
On 2018-07-18 00:35, Kevin A. McGrail wrote: What are you using in a db? Regards, KAM -- Kevin A. McGrail Hi Kevin, awl, bayes_* and userpref. Thanks, Michael
SA MySQL DB maintenance
Hi all, Does SA self-maintain the records in the DB or is there a script I should run periodically for this? Michael