Re: Queries sometimes take 1000 times the normal time

scott.marlowe wrote:
> Just to add to the clutch here, also check your bdflush settings (if
> you're on linux) or equivalent (if you're not.)
>
> Many times the swapping algo in linux can be quite bursty if you have it
> set to move too many pages at a time during cleanup / flush.

According to vmstat it doesn't swap near the spikes, so I don't think
this is the problem. I posted a vmstat sample in another reply, where
you can see an example of what happens.

Regards,
Anders K. Pedersen