MySQL Performance Example
robbie at robbiebow.co.uk
Thu May 8 15:25:51 BST 2008
Christopher Jones wrote:
> With MySQL 4.0.20 running on Apple XServe dual G5 2.5GHz, 2Gb RAM;
> mysql> select * from histones where chr='1' and location > 10000 and
> location < 20000;
Can you gives us the result of running this query:
SHOW CREATE TABLE `histones`;
EXPLAIN select * from histones where chr='1' and location > 10000 and
location < 20000;
Just so we can see the storage type, indexes &c. and how the query is
performing its search.
PS apologies to the admins for double-posting with an amendment. First
message went from a unregistered address of mine.
More information about the london.pm