0

In Microsoft SQL Server you can see Execution Plans for queries to see how a query is executed, what joins take the most time and see any missing indexs

now i want to do the same for MySQL scripts that run on a MySQL Server, i am wondering what programs or tools i can uses for this

EDIT: we have MySQL 5.5 running on Wamp and the development server so we can't use EXPLAIN

7
  • This should be asked in [dba.stackexchange.com] (which I didn't see in the list while trying to flag this as off-topic), but did you take a look at the MySQL manual, it contains nidce information with the exact phrase you're using?
    – zagrimsan
    Sep 12, 2013 at 8:05
  • @zagrimsan there's EXPLAIN however from what i've read it's really only used for SELECT queries, that's good if all i did was INSERT INTO ... SELECT however i also have alot of UPDATE queries i want checked out aswell
    – Memor-X
    Sep 12, 2013 at 22:19
  • You seem to need MySQL 5.6 or later for that.
    – zagrimsan
    Sep 13, 2013 at 7:32
  • @zagrimsan that's why i'am asking for any programs or tools i could use
    – Memor-X
    Sep 14, 2013 at 5:18
  • Sorry, I can't help you with that. You'd much better off asking this in dba.stackexchange.com
    – zagrimsan
    Sep 14, 2013 at 5:33

1 Answer 1

2

You can get a detailed plan for your query using Query Profiler feature of SQLyog. It gives detailed description about query execution and shows Explain plan. enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .