MySQL：プロセスを強制終了する

プロセスを強制終了する

コマンド KILL を使用して、実行中のプロセスを強制終了することができます。

◆書式

KILL ＜プロセスID＞

◆実行例

mysql> SHOW PROCESSLIST;
+--------+------+-----------+------+---------+------+-------+------------------+
| Id     | User | Host      | db   | Command | Time | State | Info             |
+--------+------+-----------+------+---------+------+-------+------------------+
| 283519 | root | localhost | test | Sleep   |   39 |       | NULL             |
| 283520 | root | localhost | NULL | Query   |    0 | NULL  | SHOW PROCESSLIST |
+--------+------+-----------+------+---------+------+-------+------------------+
1 row in set (0.00 sec)

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

mysql> SHOW PROCESSLIST;
+--------+------+-----------+------+---------+------+-------+------------------+
| Id     | User | Host      | db   | Command | Time | State | Info             |
+--------+------+-----------+------+---------+------+-------+------------------+
| 283520 | root | localhost | NULL | Query   |    0 | NULL  | SHOW PROCESSLIST |
+--------+------+-----------+------+---------+------+-------+------------------+
1 row in set (0.00 sec)

[対象］
MySQL 5.x.x