show processlist;からのKILL CONNECTION
実際にやってみる
準備
$ docker run -e MYSQL_ROOT_PASSWORD=pass -d mysql:5.7.24
クエリを流しておく
$ docker exec -it [container_id] /bin/bash
# mysql -h localhost -uroot -p
mysql> SELECT SLEEP(300);
別のコンソールから接続してキャンセル
$ docker exec -it [container_id] /bin/bash
# mysql -h localhost -uroot -p
mysql> show processlist;
+----+------+-----------+------+---------+------+------------+-------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+------+---------+------+------------+-------------------+
| 2 | root | localhost | NULL | Query | 9 | User sleep | SELECT SLEEP(300) |
| 4 | root | localhost | NULL | Query | 0 | starting | show processlist |
+----+------+-----------+------+---------+------+------------+-------------------+
2 rows in set (0.01 sec)
mysql>
mysql>
mysql> KILL CONNECTION 2;
Query OK, 0 rows affected (0.00 sec)