I ran iostat, what are important values to consider?
I ran the job from 12:31:51 to 12:32:18. I can see there was a noticeable
drop in tps. I should mention that this node is basically idle at this time
(it's a new development node, so no non-core processes except mysqld.
Linux 2.4.18-3 (venus)
Do you have disk performance data? My guess would be it's the time to
read the information off the disk.
I think redhat has the iostat command. Try running
iostat 1
in one window while you run your query in another, what result do you
get from the iostat?
--
Michael Conlen
Bob Ostermann wrote
