クソ重いSQLを止めるときとかね

>mysql show processlist;
+----+------+-----------------+------+---------+------+--------------+-------------------------+
| Id | User | Host            | db   | Command | Time | State        | Info                    |
+----+------+-----------------+------+---------+------+--------------+-------------------------+
| 38 | root | localhost       | roo  | Query   |    0 | NULL         | show processlist        |
| 42 | root | localhost       | roo  | Sleep   | 3794 |              | NULL                    |
| 44 | root | localhost:56042 | roo  | Query   | 3528 | Sending data | SELECT ......           |
+----+------+-----------------+------+---------+------+--------------+-------------------------+

ここでidを指定して

mysql> KILL 44;
Query OK, 0 rows affected (0.00 sec)