MySQL Query Analyzer

Question

Is there a tool for analyzing the request in more detail than EXPLAIN allows? Something like SQL Server Management Studio.

Answer 1

JetProfiler has a good graphical interface for explaining requests and allows you to customize the request in real time.

Answer 2

sqlyog is the best gui tool for querying. And there is a Query Profiler that gives this information when executing a query:

• Explain the result.
• Explain advanced.
• Change in state variables due to query execution.
• SHOW PROFILE Result.

Answer 3

If you are looking for an interface that lets you see which commands are causing errors, check out mysql workbench. However, if you are looking for a tool to tell you which commands slow your query, check this out .

Answer 4

Take a look at the Percona MySQL toolkit . It contains many useful tools, including test queries in large volumes, and not just one at a time, and a tool for graphically displaying query plans.

Answer 5

Maybe " " Explain MySQL Explanation "> can also help (detailed MySQL EXPLAIN command, forkable on github ).