All Products
Search
Document Center

KILL

Last Updated: Jun 18, 2021

Description

This statement terminates a session.

Note

If you have the PROCESS permission, you can view all the sessions. If you have the SUPER permission, you can terminate all the sessions and statements. Otherwise, you can view and terminate only your own sessions and statements.

Syntax

KILL [CONNECTION | QUERY] 'sessionid'

Parameter description

Parameter

Description

KILL

Terminates the specified threadid. This parameter is the same as KILL CONNECTION.

KILL CONNECTION

Terminates the specified threadid. This parameter is the same as the KILL statement that does not contain a modifier.

KILL QUERY

Terminates the statement that is being executed over the connection. The connection remains unchanged.

Examples

  • Terminate the connection from the session whose sessionid is 3221638213 to the statement that is being executed, and then terminate the session.

OceanBase(admin@test)>show processlist;
+------------+-------+--------------------+------+---------+------+--------+------------------+
| Id         | User  | Host               | db   | Command | Time | State  | Info             |
+------------+-------+--------------------+------+---------+------+--------+------------------+
| 3221638212 | admin | 1.11.111.127:11161 | test | Query   |    0 | ACTIVE | show processlist |
| 3221638213 | admin | 1.11.111.127:11161 | test | Query   |    0 | ACTIVE | select "abcedfg" |
+------------+-------+--------------------+------+---------+------+--------+------------------+
1 row in set (0.03 sec)

OceanBase(admin@test)>kill query 3221638213;
Query OK, 0 rows affected (0.01 sec)

OceanBase(admin@test)>kill 3221638212;
Query OK, 0 rows affected (0.01 sec)