Is there any tool to optimize MySQL Queries? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

开发者_如何转开发

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 3 years ago.

Improve this question

I am undergoing the performance test on MySQL and i need your guidance.If there is any tool available to optimize the MySQL Queries.Please let me know.The tool i am seeking for is one which would be useful to identify the query which causing the memory leak.

Thanks,

---

using EXPLAIN in front of your query is a good starting point to understand what is going bad or too slow. So you can improve performances using primary/foreign keys and indexes.
A query, as Mitch Wheat said, doesn't produce a memory leak; maybe it takes a lot of time and consumes a lot of ram, but there are different reasons for this.

---

Take a look at this - EverSQL. This seems to be a good tool, however it can only optimize select queries.

---

Take a look at this one - Query Profiler

---

You can use: EXPLAIN and EXPLAIN EXTENDED

---

User wampserver, it provides a mysql gui.