What are the free tools available to find the slow queries of MySQL? apart from logging the slow queries.
Need to analysis the slow queries in detail.
Thanks, Kathir
Use EXPLAIN
. Example:
explain select * from your_table
Have a look at this tool - Neor Profile SQL.
Neor Profile SQL - an application that catches all requests from the client and works as a proxy server. This technology allows you to take under control all access to the database and identify bottlenecks in requests.
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