I keep finding it extremely peculiar that a count(*) on a MyISAM table would take that
long. InnoDB needs to effectively *count* the records, but MyISAM keeps accurate
statistics and can just read it from the metadata.
This suggests to me that not all your metadata (ie., table descriptors et al) can be kept
in memory. That's just a hunch, though, and I haven't actively followed this thread.
Another possibility I see is that the table is kept locked by long-running transactions
(or by a shitload of activity on it) - I /think/ that also prevents access to the
metadata. Does "show open tables" show something?
As a longer shot (almost over the horizon, really) could something be stopping mysqld from
accessing the table's datafiles or slowing that access down considerably?
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel