MySQL Performance Example

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

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.


More information about the london.pm mailing list