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;