KILL CONNECTION
更新时间：2025-10-16
描述
杀死一个指定连接 ID 的连接。进而会杀死此连接对应的查询。
语法
SQL
1KILL [ CONNECTION ] <connection_id>必选参数
<connection_id>
链接的 ID。可以通过 SHOW PROCESSLIST 语句查询。
权限控制
执行此 SQL 命令的用户必须是此连接所属的用户，或者至少具有ADMIN_PRIV权限
示例
查询 connection_id:
SQL
1show processlist;结果如下：
SQL
1+------------------+----+------+-----------------+---------------------+----------+------+---------+------+-------+-----------------------------------+------------------+--------------+--------------+
2| CurrentConnected | Id | User | Host | LoginTime | Catalog | Db | Command | Time | State | QueryId | Info | FE | CloudCluster |
3+------------------+----+------+-----------------+---------------------+----------+------+---------+------+-------+-----------------------------------+------------------+--------------+--------------+
4| Yes | 16 | root | 127.0.0.1:63746 | 2024-11-04 20:18:07 | internal | test | Query | 0 | OK | e4d69a1cce81468d-91c9ae32b17540e9 | show processlist | 172.16.123.1 | NULL |
5+------------------+----+------+-----------------+---------------------+----------+------+---------+------+-------+-----------------------------------+------------------+--------------+--------------+发送 KILL 命令
SQL
1KILL CONNECTION 16;