Re: spamd process using to much cpu (again)

[Matias Lopez Bergero]

Michael Parker wrote:
On Thu, Dec 02, 2004 at 04:25:46PM -0300, Matias Lopez Bergero wrote:
From time to time, some spamd process sticks on top of the top listing 
with an ~90% CPU utilization
There is a way to prevent this?
>
Possibly.
What can be causing this hi CPU usage?
 
I can't be 100% sure, but I'd put money on bayes expiration, which can
be very CPU and IO intensive while it runs.
Yes, I forgot to say that I was also having an increasing iowait usage.
Some times I see about 150 to 190% of the CPU resources waisted iowait.
Depending on your setup you could turn off bayes_auto_expire and do
the expiration manually (ie sa-learn --force-expire), at a time that
you control.  Unfortunately, unless you are running a sitewide bayes
config, this may not work well with a lot of individual bayes dbs.
I am running sitewide installation.
But now I got another question.
I need to run sa-learn by hand? There is no way to configure spamd to do 
that??

If you're running 3.0, you could move your bayes databases to SQL
which has a much faster expiration time (roughly 7 times faster).
This would also allow you to offload some of the CPU and IO
consumption to a separate machine.
That would be nice :)
Unfortunately I cannot put the bayes db on another machine, but I have a 
local mysql service, so if that improves the performance I could move 
the bayes db there.
What would be your suggestion?

Hope that helps.
It really helps,
Thank you!
Matías.