Is there a way to analyze indexes on MySQL?
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
The indexes themselves cannot be analyzed, but we can use the EXPLAIN functionality to analyze a the INDEX usage of a query. The EXPLAIN syntax is detailed at http://dev.mysql.com/doc/mysql/en/EXPLAIN.html.
Dig Deeper on Linux servers
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.