United-States flag

0

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:

SQL code:

  1. 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?

Like this post? Share it!

Join Our Community!

Join our community and participate in the discussions!

Stats

people

1

1 Follower