Skip to content

Instantly share code, notes, and snippets.

@jineshpaloor

jineshpaloor/find_expensive_query.sql

Created March 4, 2014 13:35
Show Gist options
  • Save jineshpaloor/9346603 to your computer and use it in GitHub Desktop.
Save jineshpaloor/9346603 to your computer and use it in GitHub Desktop.
Download ZIP
query to find the queries which is taking long time to process.
Raw
find_expensive_query.sql
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST where COMMAND = "query" and Time > 1 order by time asc;SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST where COMMAND = "query" and Time > 1 order by time asc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment