重いMYSQLのプロセスを強制的に切る方法
以下のとおり
mysql> SHOW PROCESSLIST; +------+--------+-----------+------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+--------+-----------+------+---------+------+-------+------------------+ | 3295 | aauser | localhost | test | Sleep | 1996 | | NULL | | 3323 | root | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST | +------+--------+-----------+------+---------+------+-------+------------------+ 2 rows in set (0.00 sec) mysql> kill 3295; Query OK, 0 rows affected (0.00 sec) mysql> SHOW PROCESSLIST; +------+------+-----------+------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+-----------+------+---------+------+-------+------------------+ | 3323 | root | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST | +------+------+-----------+------+---------+------+-------+------------------+ 1 row in set (0.00 sec)