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
Hi-
I'm running mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) / RedHat
7.3 on a AMD 2400XP 256 MB.
I've got a table (type=MyISAM) that's grown to 1,7 GB (154,815 records) and
it takes several seconds to perform even simple querys:
select data from eod where symbol='ZOOM'
yields: 1 row
