show full processlist order by Time?

[avilella]

Hi,

Can I somehow order the list of processes by the Time field?

[John Murtari]

Post by avilella
Can I somehow order the list of processes by the Time field?

Not with "SHOW PROCESSLIST", the syntax to add an order by is
not supported.

If you are running 5.1.x -- they do have an INFORMATION_SCHEMA
table for PROCESSLIST. We don't run that here, but you should be
able to do:

USE INFORMATION_SCHEMA;
SELECT * FROM PROCESSLIST ORDER BY Time;