Optimizing DSPAM + MySQL 4.1

Posted by falko on Apr 19, 2006 7:51 PM EDT
HowtoForge; By Lasse Laursen
Mail this story
Print this story

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

DSPAM is a scalable and open-source content-based spam filter designed for multi-user enterprise systems. It is great at filtering out spam but on busy mailservers the pruning of the MySQL databases takes way too much 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.

http://www.howtoforge.com/optimizing_dspam_mysql4.1

Full Story

  Nav
» Read more about: Story Type: Tutorial; Groups: MySQL

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.