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