MySQLで接続中のスレッドや実行中のSQLを確認する

MySQLで、接続中のスレッドや実行中のSQLを確認するには以下のようにすれば良い。

mysql> show processlist;
+-----+------+-----------------+----------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------------+----------+---------+------+-------+------------------+
| 270 | user | localhost:19549 | dbname | Query | 0 | NULL | show processlist |
+-----+------+-----------------+----------+---------+------+-------+------------------+
1 row in set (0.00 sec)