Tuesday, April 9, 2013

Sortable Output MySQL Show Processlist

This will sort the output by username. Substitute select's and order's as needed.
SELECT id,user,db,command,time,state FROM INFORMATION_SCHEMA.PROCESSLIST order by user;