Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Our MySQL database diet
  FAQ FAQ  Forum Search   Register Register  Login Login

Our MySQL database diet

 Post Reply Post Reply
Author
Analytical View Drop Down
Newbie
Newbie
Avatar

Joined: 28 February 2006
Location: United States
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Analytical Quote  Post ReplyReply Direct Link To This Post Topic: Our MySQL database diet
    Posted: 28 February 2006 at 4:35pm

We found after the Spamfilter service ran for awhile (several months) the database became bloated and we had to run a manual cleanup to make it lose weight. When bloated it was very slow.  If you have trouble with a bloated database -- here was our solution:

We modified the tblmsgs and tblquarantine tables slightly to include a time stamp to better age them.  We set our spamfilter database settings to store rejected emails for three (3) days.

We also wrote a service that checks for any record in the tblmsgs and tblquarantine tables that is four (4) days old or older and purges them.  The service runs hourly and we limit the amount it can purge to 10,000 records.

The service catches any rejected emails in the tables missed by the spamfilter program, and does not requre a relational match.  Now our database is tiny and very fast. 

His and yours,

Dwight
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.219 seconds.