Re: Executing same query in 1 moment

[Rick James]

> there is no way to optimize them more.
Ah, I like a challenge!

But first, I need some details... 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
* SHOW VARIABLES LIKE 'query%';
* SHOW GLOBAL STATUS LIKE 'Qc%';
and surround them with [ code ] and [ / code ]
How much RAM do you have?