Re: slow queries, possibly disk io

Hi,

I had some disk io issues recently with NFS, I found the command 'iostat 
-x 5' to be a great help when using Linux.

For example here is the output when I do a 10GB file transfer onto hdc
Device:    rrqm/s wrqm/s   r/s   w/s  rsec/s  wsec/s    rkB/s    wkB/s 
avgrq-sz avgqu-sz   await  svctm  %util
hdc          0.00 875.95  0.00 29.66    0.00 7244.89     0.00  3622.44   
244.27     3.07  103.52   1.78   5.27

The last field show the disk is 5.27% busy.

I have seen this value at 100%, adding more server brought it under 100%.
It seems that if you hit 100% problems sort of cascade all over that 
place. For example Apache connections went right up and hit their max.

I am not sure how accurate the % is but it has work pretty well for me.

Perhaps use this command in another window with you run your SQL and see 
what it shows.

HTH.
Kind regards,
Rudi.