Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL debugging tool slow queries? [closed]

Tags:

mysql

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

like image 719
Kathir Avatar asked Oct 11 '12 15:10

Kathir


2 Answers

Use EXPLAIN. Example:

explain select * from your_table
like image 170
juergen d Avatar answered Sep 29 '22 07:09

juergen d


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.

like image 22
Devart Avatar answered Sep 29 '22 07:09

Devart



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!