MySQLで重いSQLを中断する方法

mysql memo

結果が一生返ってこなさそうなSQLを実行してしまったときに，実行を中止する方法．

$ mysqladmin -u root -p processlist
Enter password:

+-----+------+-----------+------------+---------+------+--------------+--------------------------------------------------------------------+
| Id  | User | Host      | db         | Command | Time | State        | Info                                                               |
+-----+------+-----------+------------+---------+------+--------------+--------------------------------------------------------------------+
| 113 | pma  | localhost | phpmyadmin | Sleep   | 740  |              |                                                                    |
| 114 | root | localhost | technorati | Query   | 740  | Sending data | INSERT INTO `table`.`column` SELECT * FROM `table2`.`column`       |
| 118 | root | localhost |            | Query   | 0    |              | show processlist                                                   |
+-----+------+-----------+------------+---------+------+--------------+--------------------------------------------------------------------+

$ mysqladmin -u root -p kill 114