HowtoForge: Optimizing DSPAM + MySQL 4.1

[ Thanks to Falko Timme for this link. ]

"DSPAM is a scalable and open-source content-based spam filter designed for multi-user enterprise systems. It's great at filtering out spam but on busy mailservers the pruning of the MySQL databases takes way too long time...

"The default purge-4.1.sql script provided with DSPAM can be heavily optimized by adding indexes to the database and using the indexes properly when pruning..."

Complete Story

Related Stories:

• Adminspotting: Stories of Spam, Part 1(Mar 14, 2006)
• Linux.com: Implementing a Postfix Mail Server with Spam and Antivirus Protection(Mar 13, 2006)
• AllYourTech: Installing AntiVir, With On-access Scanning, in Ubuntu Linux(Jan 18, 2006)
• Linux/BSD Gangsters: Bringing The Power of ClamAV To The KDE Desktop(Jan 15, 2006)