How to know which query is taking long time? (Sloved)

It will tell you the query which is slowing down you system

SET GLOBAL slow_query_log = 'ON';
SELECT * FROM mysql.slow_log ORDER BY start_time DESC

Comments