order `show processlist` in mysql and other tricks
I wanted to order `show processlist` by Time, limit to few, in short - use all mighty use mysql!
I found out that 5.1.7+ versions of MySQL support the process list in information_schema:
- mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY TIME DESC LIMIT 10;
That you can ORDER BY in any way you like. What is your best trick with mighty processlist?
Join Our Community!