Peter Peltonen wrote:
> On 12/24/06, Alexey Loukianov <[EMAIL PROTECTED]> wrote:
>> Did you check with vmstat or top the state of iowait? Maybe your
>> processors are idle because of heavy disk load they are waiting to
>> finish?
>
> iostat tells me:
>
> avg-cpu:
> %user %nice %sys %iowait %idle
> 6.77 0.00 1.23 8.28 83.72
>
> Isn't ioawait a bit uncertain measure? I mean with the same disks if
> you replace a faster processor iowait will grow as the cpu does it's
> thing faster and has more time to wait the disks, so you really can't
> compare two system's iowait values if their hardware aren't
> identical... I have a 2.8GHz hyperthreading CPU and two SAMSUNG
> SP1604N PATA disks running in UDMA5 mode doing software RAID1.
>
>
> vmstat -m tells me:
>
> procs memory swap io
> system cpu
> r b swpd free buff cache si so bi bo in cs us sy
> id wa
> 0 0 385 23 146 197 0 0 10 2 22 17 7
> 1 12 8
>
>
> If the system was swapping heavily, so and si values would be high,
> right? Are my bi and bo values reasonable?
>
>
>
>> Rebooting the server don't help in my case. Disabling only the
>> autolearn feature also don't help. To get rid of the issue I have to
>> totally disable bayest rules in SA. Nothing else helps.
>
> Do you have any guesses why bayes rules checking is causing the
> troubles?
Is bayes_auto_expire on? That caused timeouts for me, though not mysql.
> And isn't spamassassin quite useless without it?
Not exactly. It still has many static rules that can catch a lot of things.
bayes rules are only the ones that you teach it, either via autolearn or
sa-learn.
> And does anyone have any idea why these problems are causing mysql to
> hang (or they other way around)? And would anyone have any info how to
> go debugging what's happening with mysql?
Can't help you there off hand.
> Regards,
> Peter
>
--
-Eric 'shubes'
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
