MySQLで現在実行中のプロセス一覧を確認する

SQL実行プロセスを確認する

SHOW PROCESSLIST

+----+------+----------------+--------+---------+------+-------+------------------+
| Id | User | Host           | db     | Command | Time | State | Info             |
+----+------+----------------+--------+---------+------+-------+------------------+
|  9 | root | localhost:4049 | testdb | Sleep   |   39 |       | NULL             |
| 13 | root | localhost:4451 | test   | Query   |    0 | NULL  | SHOW PROCESSLIST |
+----+------+----------------+--------+---------+------+-------+------------------+
2 rows in set (0.00 sec)

SQL実行プロセスを確認する(SQLクエリを全文表示)

SHOW FULL PROCESSLIST

*************************** 1. row ***************************
     Id: 13
   User: root
   Host: localhost:4451
     db: test
Command: Query
   Time: 0
  State: NULL
   Info: SHOW PROCESSLIST
*************************** 2. row ***************************
     Id: 14
   User: root
   Host: localhost:4764
     db: testdb
Command: Query
   Time: 6
  State: Sending data
   Info: SELECT SHOHIN_ID, SHOP_ID, SHOP_NM, SHOHIN_NM, TEXT_SHORT, SHOHIN_SPEC,
TEXT_LONG, PRICE, TAX FROM t
2 rows in set (0.00 sec)

参考URL

http://mysql.javarou.com/dat/000582.html