Note
This variable is available starting with V2.1.
Description
max_user_connections specifies the maximum number of connections that a single user can establish to an OBServer node.
Privilege requirements
Query variables
Global level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to obtain the value of a global system variable.Session level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode) or theinformation_schema.SESSION_VARIABLESview (MySQL mode) to obtain the value of a session system variable.
Modify variables
systenant can modify the value of a global system variable.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.Oracle user tenants must have the
ALTER SYSTEMprivilege to modify the value of a global system variable.
Attributes
| Attribute | Description |
|---|---|
| Type | Uint |
| Default value | 0, indicating that no limit is set. |
| Value range | [0, 4294967295] |
| Scope |
|
| Modifiable | You can execute the SET GLOBAL statement to modify the value of the variable in global mode. You cannot execute the ALTER SESSION SET statement to modify the value of the variable in session mode. |
Examples
Set the maximum number of connections that a single user can establish to an OBServer node to be unlimited.
obclient> SET GLOBAL max_user_connections =0;