MySql query analyzer - free solutions

Question

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?

I take it you are aware of EXPLAIN? http://dev.mysql.com/doc/refman/5.0/en/explain.html — Pekka, Jan 13 '10 at 13:21
Yes, however looking for something like the MsSQL version... — frank, Jan 13 '10 at 13:28

score 4 · Answer 1 · answered Feb 07 '14 at 15:46

4

Maybe "MySQL Explain Explain" can help (verbose version of MySQL EXPLAIN command, forkable on github).

answered Feb 07 '14 at 15:46

rap-2-h

30,204
37
167
263

Yaronius · Answer 2 · 2013-08-15T13:57:52.883

4

You may want to try Percona tools for MySQL. Look at this article

edited Aug 15 '13 at 13:57

answered Mar 16 '11 at 10:30

Yaronius

784
3
17
34

score 1 · Answer 3 · answered Jan 13 '10 at 14:17

1

https://enterprise.mysql.com

30 day trial...

answered Jan 13 '10 at 14:17

frank

495
1
7
13

MySql query analyzer - free solutions

3 Answers3

Linked