実行中のクエリを確認

MySQL

いつも忘れてしまうのでメモメモ。
現在実行中のクエリ(SQL)を確認するには…

mysql> show processlist;
+----+------+-----------+--------+---------+------+----------------+----------------------------------+
| Id | User | Host      | db     | Command | Time | State          | Info                             |
+----+------+-----------+--------+---------+------+----------------+----------------------------------+
| 12 | root | localhost | zabbix | Query   |    1 | creating table | ALTER TABLE httptest TYPE=InnoDB |
| 13 | root | localhost | mysql  | Query   |    0 | NULL           | show processlist                 |
+----+------+-----------+--------+---------+------+----------------+----------------------------------+
2 rows in set (0.00 sec)

mysql>