Home / server / Questions / 179090
Accepted
Andrew Winter
Asked: 2010-09-09 00:51:27 +0800 CST

Listing MySQL JOINS with no index

  • 772

Is there a way to generate a list of JOINS being performed without indexes in MySQL?

mysql indexes

1 Answers

  1. Best Answer

    If you have available a list of SELECT queries your application performs, just put log-queries-not-using-indexes in your my.cnf, restart MySQL and execute all the SELECTs. Then read the log file.

    Alternatively you can run EXPLAIN SELECT your_query_using_JOIN and read the output.

    • 4