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 ==============================================
