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) 06/26/2003
Time: 12:31:48 PM Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
Time: 12:31:49 PM dev3-0 219.00 5128.00 0.00 5128 0
Time: 12:31:50 PM dev3-0 216.00 4688.00 0.00 4688 0
Time: 12:31:51 PM dev3-0 181.00 3976.00 0.00 3976 0
Time: 12:31:52 PM dev3-0 139.00 2824.00 0.00 2824 0
Time: 12:31:53 PM dev3-0 129.00 2056.00 176.00 2056 176
Time: 12:31:54 PM dev3-0 133.00 2296.00 0.00 2296 0
Time: 12:31:55 PM dev3-0 136.00 2720.00 0.00 2720 0
Time: 12:31:56 PM dev3-0 115.00 2664.00 0.00 2664 0
Time: 12:31:57 PM dev3-0 119.00 3024.00 0.00 3024 0
Time: 12:31:58 PM dev3-0 147.00 3008.00 224.00 3008 224
Time: 12:31:59 PM dev3-0 152.00 3360.00 0.00 3360 0
Time: 12:32:00 PM dev3-0 143.00 3200.00 0.00 3200 0
Time: 12:32:01 PM dev3-0 153.00 3408.00 0.00 3408 0
Time: 12:32:02 PM dev3-0 149.00 3264.00 0.00 3264 0
Time: 12:32:03 PM dev3-0 151.00 3264.00 48.00 3264 48
Time: 12:32:04 PM dev3-0 150.00 3304.00 0.00 3304 0
Time: 12:32:05 PM dev3-0 156.00 3376.00 0.00 3376 0
Time: 12:32:06 PM dev3-0 136.00 2856.00 0.00 2856 0
Time: 12:32:07 PM dev3-0 143.00 2952.00 0.00 2952 0
Time: 12:32:08 PM dev3-0 133.00 3152.00 624.00 3152 624
Time: 12:32:09 PM dev3-0 147.00 3080.00 0.00 3080 0
Time: 12:32:10 PM dev3-0 158.00 3648.00 0.00 3648 0
Time: 12:32:11 PM dev3-0 153.00 3584.00 0.00 3584 0
Time: 12:32:12 PM dev3-0 162.00 3848.00 0.00 3848 0
Time: 12:32:13 PM dev3-0 158.00 3704.00 80.00 3704 80
Time: 12:32:14 PM dev3-0 161.00 3848.00 0.00 3848 0
Time: 12:32:15 PM dev3-0 159.00 3816.00 0.00 3816 0
Time: 12:32:16 PM dev3-0 157.00 3680.00 0.00 3680 0
Time: 12:32:17 PM dev3-0 152.00 3616.00 0.00 3616 0
Time: 12:32:18 PM dev3-0 170.00 4000.00 48.00 4000 48
Time: 12:32:19 PM dev3-0 229.00 5376.00 0.00 5376 0
Time: 12:32:20 PM dev3-0 236.00 5664.00 0.00 5664 0
Time: 12:32:21 PM dev3-0 238.00 5664.00 0.00 5664 0
Time: 12:32:22 PM dev3-0 225.00 5232.00 0.00 5232 0
Time: 12:32:23 PM dev3-0 208.00 4776.00 120.00 4776 120
Time: 12:32:24 PM dev3-0 220.00 5280.00 0.00 5280 0
Time: 12:32:25 PM dev3-0 249.00 5752.00 0.00 5752 0
Time: 12:32:26 PM dev3-0 220.00 5216.00 0.00 5216 0
Time: 12:32:27 PM dev3-0 236.00 5648.00 0.00 5648 0
At 10:31 AM 6/26/03 -0400, you wrote:
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 in set (3.15 sec)
(data is about 29K)
a repeat of the query yields 0.00 seconds, so the slowdown appears to be in the initial accessing of the data, not the handling/display of the result.
nearby records (key 'ZOWI') execute faster (1 row in set (0.28 sec)) but still slowly.
this is the create:
CREATE TABLE `eod` ( `symbol` varchar(10) binary NOT NULL default '', `updated` date default NULL, `data` mediumtext, PRIMARY KEY (`symbol`) ) TYPE=MyISAM
Is there a relationship between filesystem/recordsize/recordcount that needs to be optimized for this type of table?
bob.
============================================== The RediNews Network http://www.redinews.com/ Custom Financial Web Site Content phone: (516) 997-4343 ==============================================
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
============================================== The RediNews Network http://www.redinews.com/ Custom Financial Web Site Content phone: (516) 997-4343 ==============================================
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
