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