查看mysql当前的执行任务，并关闭其中的指定任务

1. 查询当前任务列表

 

SHOW FULL PROCESSLIST;
-----------------+
| Id | User | Host            | db   | Command | Time | State        | Info                                  |
+----+------+-----------------+------+---------+------+--------------+---------------------------------------+
| 5  | root | 192.168.1.1:123 | mydb | Query   | 120  | Sending data | SELECT * FROM large_table WHERE ...   |
+----+------+-----------------+------+---------+------+--------------+---------------------------------------+

 

2. 结束指定任务

 
KILL 5;