MySQL query analyzer

Question

Is there a tool to analyze query more thoroughly than EXPLAIN allows? Something like SQL Server Management Studio.

Answer 1

JetProfiler has a good GUI for explaining queries, and letting you tweak the query in real time.

Answer 2

sqlyog is a best gui tool for query. And there is Query Profiler which gives these informations when you execute a query:

• Explain result.
• Explain Extended.
• Change Of Status Variables Due ToExecution Of Query.
• SHOW PROFILE Result.