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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
