Our MySQL database diet |
Post Reply |
Author | |
Analytical
Newbie Joined: 28 February 2006 Location: United States Status: Offline Points: 4 |
Post Options
Thanks(0)
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 |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.219 seconds.