Skip to content

Instantly share code, notes, and snippets.

@maheshgawali

maheshgawali/most_time_consuming_cmd.sql

Last active April 16, 2020 10:12
Show Gist options
  • Save maheshgawali/9d9ebc7bf10e0f7864c2be7befa9c9b8 to your computer and use it in GitHub Desktop.
Save maheshgawali/9d9ebc7bf10e0f7864c2be7befa9c9b8 to your computer and use it in GitHub Desktop.
Download ZIP
get the most time consuming cmd from mysql (innodb)
Raw
most_time_consuming_cmd.sql
# HIGHEST TIME CONSUMING QUERY AT PRESENT
select ID,INFO,COMMAND,STATE, TIME from information_schema.processlist where STATE != 'Sleep' and COMMAND!='Sleep' order by TIME desc limit 1\G
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment