MySQLで重いSQLを中断する方法
結果が一生返ってこなさそうな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