...
Please enter comments here. You can type @''SIG@ to insert your signature. – DuncanFindlay 50:06Z)
...
As with file-based AWL, the SQL version grows without bounds. I've forgotten where I found the original recommendation, but adding another column like this:
{{lastupdate
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,}}
and adding a cron job to periodically trim entries that haven't been touched in a while:
mysql spamassassin -e 'DELETE FROM awl WHERE lastupdate <= DATE_SUB(SYSDATE(), INTERVAL 2 WEEK);'
helps keep it under control. This is especially important if you've made efforts to put the MySQL data store on a RAMdisk of some kind...
– Kris Deugau 2009-08-27