Menu
Is there a good Query Analyzer for MySQL (that's either free, or has a trial), that can analyse a query and make suggestions for indexes, like the "Display estimated execution plan" in Microsoft SQL Server management studio?
402
To run the query in Query Analyzer, first paste the contents into Query Analyzer, then go to the toolbar and select Query | Show Execution Plan. Next, highlight the SQL to execute and press F5.
The MySQL Query Analyzer enables you to monitor SQL statements executed on a MySQL server and displays the details of each query, number of executions and execution times. Similar queries with different literal values are combined for reporting purposes.
Query Profiler, built into dbForge Studio for MySQL, is the best query optimization tool to tune MySQL queries and investigate query performance issues in an efficient and fast way. It helps build up a picture of how the queries are run to access data and what operations impact your application.
You may want to try Percona tools for MySQL. Look at this article
196
Maybe "MySQL Explain Explain" can help (verbose version of MySQL EXPLAIN command, forkable on github).
22
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
