Skip to content

Instantly share code, notes, and snippets.

@cbmeeks
Created August 9, 2012 12:36
Show Gist options
  • Save cbmeeks/3303843 to your computer and use it in GitHub Desktop.
Save cbmeeks/3303843 to your computer and use it in GitHub Desktop.
MySQL Process List
SELECT
ID
, USER
, HOST
, DB
, COMMAND
, TIME
, time/60.0 Seconds
, (time/60.0) / 60.0 Hours
, STATE
, LEFT(INFO, 51200) AS Info
from information_schema.PROCESSLIST
order by
user
, time desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment