Terminate a tenant session

OceanBase Database allows you to terminate tenant sessions by using the KILL statement.

The syntax of the SQL statement is as follows:

KILL [CONNECTION] 'session_id';

The rules for using the statement are as follows:

• You can execute the KILL statement to terminate only one session at a time.

• In MySQL-compatible mode, a normal user can view all sessions if they have the PROCESS privilege. If they have the SUPER privilege, they can terminate all sessions and statements one by one. Otherwise, they can only view and terminate their own sessions and statements. A tenant administrator can terminate all sessions and statements one by one.

  For information about how to view your privileges in MySQL-compatible mode, see View user privileges. If you do not have the required privileges, contact the administrator to obtain the privileges. For more information, see Grant direct privileges.

• In Oracle-compatible mode, a normal user can only view and terminate their own sessions and statements. If they have the SHOW PROCESS privilege, they can view all sessions. A tenant administrator can terminate all sessions and statements one by one.

  For information about how to view your privileges in Oracle-compatible mode, see View user privileges. If you do not have the required privileges, contact the administrator to obtain the privileges. For more information, see Grant direct privileges.

The syntax for terminating a specified session is as follows:

KILL session_id;

Alternatively, use the following syntax:

KILL CONNECTION session_id;

You need to replace session_id with the corresponding session ID, which can be obtained by using the SHOW PROCESSLIST or SHOW FULL PROCESSLIST statement. For more information about how to obtain the session ID, see View tenant sessions.

For more information about the KILL statement, see KILL in SQL Reference (MySQL Mode), or KILL in SQL Reference (Oracle Mode).

References

• Privilege types in MySQL-compatible mode

• Privilege types in Oracle-compatible mode

• View tenant sessions

• Set the maximum number of connections for a tenant