Re: Big problems on optimizing query

[Rick James]

Please be more explicit:
* 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 ]

There are more details in the EXPLAIN that I need to see.

How much RAM do you have?

You could try OPTIMIZE TABLE -- it might help.