Re: random slow query

top - 10:18:58 up 224 days, 15:10, 2 users, load average: 6.27, 7.33, 6
Tasks: 239 total, 1 running, 238 sleeping, 0 stopped, 0 zombie
Cpu(s): 5.0%us, 0.7%sy, 0.0%ni, 61.5%id, 32.7%wa, 0.0%hi, 0.1%si, 0
Mem: 32962804k total, 32802612k used, 160192k free, 325360k buffers
Swap: 8193140k total, 224916k used, 7968224k free, 30829456k cached

Didn't really see the pattern, typical the cpu load is only about 40%

On Mon, Jun 29, 2009 at 7:26 PM, Mike Ivanov<mikei(at)activestate(dot)com> wrote:
> Hi Sean,
>
> Sean Ma wrote:
>>
>> One months ago, this type of slow query happened about a few time per
>> day. But recently, the slow query happens more frequent at the rate of
>> once every 10 minutes or less. There seesm not relation to th
>
> What is your hardware (memory, CPU type and such)?
>
> This seems like a cache issue to me, but I can't tell for sure without some
> additional information on your system:
>
> 1) What is the amount of a) available memory b) free memory and c) memory
> available to i/o buffers?
>
> 2) What is the swap usage if any?
>
> 3) What is the CPU load? Any noticeable patterns in CPU load?
>
> You can use /usr/bin/top to obtain most of this information.
>
> Mike
>
>
>