mysql – How to identify queries using no index?


After a long time, I decided to check the status of the database, even if everything was working normally. I used the mysqltuner.pl to check.


At some point, there is the following information:

(!!) Joins performed without indexes: 8915215
(OK) Temporary tables created on disk: 0% (6K on disk / 19B total)

My question is:

How to quickly identify which JOINS do not use index?