[Spamassassin Wiki] Update of "BetterDocumentation/SqlReadmeAwl" by KrisDeugau

[Apache Wiki <wi...@apache.org>]

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Spamassassin Wiki" for change notification.

The following page has been changed by KrisDeugau:
http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeAwl

------------------------------------------------------------------------------
  
  Please enter comments here. You can type @''''''SIG@ to insert your signature. -- DuncanFindlay [[DateTime(2005-08-22T02: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
+