MySQL Performance Example

[Robbie Bow]

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`;

and

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.

Cheers

PS apologies to the admins for double-posting with an amendment. First
message went from a unregistered address of mine.