Re: Slow simple query in 4000000 records table

[Zsolt Kendi]

The standard RJ questions:

"To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with

 and 

"

My additionls:
* The datat directory of mysqld located at what kind of disk (single, raid, SSD, RAM)
* The server hardware description (CPU, MEM ...).