Ítalo Rossi wrote: > Hello, > > We have postfix 2.3.7-3 + dspam 3.6.8 + mysql 4.1 storage running on > debian etch. A few days ago the queue of my server was bigger, and my > database is very slow, so.. what can I do to fix this problem? >
First of all, try converting your tables to InnoDB, then add some indexes to increase cleanup speed, specifically an index in the date. The scripts will have to change to use the indexes though. Then check the IO in your box. If you have a single SATA drive, you DB *might* be saturating your IO. There are tons of ways to tune up mysql to decrease the IO level, and increase performance. Most of DSPAM work in actually done in the database, so, make sure it is tuned up. Cheers
