MySQL如何查询当前正在执行什么语句

可以使用

mysql> show processlist;
+--------+------+---------------------+--------+---------+-------+----------+------------------+
| Id     | User | Host                | db     | Command | Time  | State    | Info             |
+--------+------+---------------------+--------+---------+-------+----------+------------------+
| 140639 | root | localhost           | jm     | Query   |     0 | starting | show processlist |
| 142056 | root | 172.19.0.31:38190   | tester | Sleep   | 22310 |          | NULL             |
| 149174 | root | 172.19.0.31:36866   | tester | Sleep   | 15110 |          | NULL             |
| 153668 | root | 172.16.10.244:55836 | jm     | Sleep   |     8 |          | NULL             |
| 154607 | root | 172.19.0.31:52368   | tester | Sleep   |  9710 |          | NULL             |
| 157886 | root | 172.19.0.33:59530   | tester | Sleep   |  6409 |          | NULL             |
| 159997 | root | 172.19.0.31:39532   | tester | Sleep   |  4310 |          | NULL             |
| 161501 | root | 172.16.10.244:54176 | NULL   | Sleep   |    19 |          | NULL             |
| 163015 | root | 172.19.0.31:44832   | tester | Sleep   |  1310 |          | NULL             |
| 163017 | root | 172.19.0.33:34716   | tester | Sleep   |  1309 |          | NULL             |
| 163318 | root | 172.19.0.33:46530   | tester | Sleep   |  1009 |          | NULL             |
| 163619 | root | 172.19.0.31:40288   | tester | Sleep   |   710 |          | NULL             |
| 163621 | root | 172.19.0.33:58398   | tester | Sleep   |   709 |          | NULL             |
| 163922 | root | 172.19.0.33:41958   | tester | Sleep   |   409 |          | NULL             |
| 164222 | root | 172.19.0.31:35676   | tester | Sleep   |   110 |          | NULL             |
| 164224 | root | 172.19.0.33:53780   | tester | Sleep   |   109 |          | NULL             |
+--------+------+---------------------+--------+---------+-------+----------+------------------+
16 rows in set (0.00 sec)