Spam Filter ISP Forums : Our MySQL database diet

Spam Filter ISP Forums : Our MySQL database diet https://www.logsat.com/spamfilter/forums/ Sat, 18 Apr 2026 16:13:51 +0000 Tue, 28 Feb 2006 16:35:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=5528 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Our MySQL database diet : We found after the Spamfilter...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5528&PID=7504&title=our-mysql-database-diet#7504 Author: Analytical
Subject: 5528
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.

]]> Tue, 28 Feb 2006 16:35:16 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5528&PID=7504&title=our-mysql-database-diet#7504