Re: How to improve the performance of read ?

[Rick James]

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 [ code ] and [ / code ]
How much RAM do you have?

The answer to your performance problem may involve
* Adding or changing INDEXes
* Tuning
* Modifying the SELECTs
* Redesigning the schema
* Creating and maintaining summary tables
* other.