Overview

Internal commands supported by OceanBase Database Proxy (ODP) can be divided into dedicated ODP commands and compatible MySQL commands. The privilege limitations on running these commands are described as follows:

• Dedicated ODP commands can be executed only by the super administrator root@sys of OceanBase Database and the super administrator root@proxysys of ODP. Other users are not authorized to run these commands.

• Among the compatible MySQL commands, only the super administrator root@proxysys of ODP can execute the SHOW PROCESSLIST statement to query the session information about all tenants in the current cluster, and the KILL statement to terminate a session of any tenant in the cluster. A user in the sys tenant of an OceanBase cluster can execute the SHOW PROCESSLIST statement to query the session information about all tenants in the current cluster, and the KILL statement to terminate any session in the current tenant. Other normal users in user tenants can perform operations only on sessions of the current user based on their privileges. By default, a normal user can only execute the SHOW PROCESSLIST statement to query the session information of the current user but cannot query the cluster information.

Take note of the following considerations:

• If an internal command is successfully identified but an internal ODP error occurs during the parsing and encapsulation of packets, ODP returns the following error to the client: ERROR 4081 (HY000): Unknown result.

• For a dedicated ODP command that can only be partially identified, such as show proxysession ??, ODP considers that the command format is incorrect and returns the following error to the client: ERROR 5010 (21000): Unknown operator.