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 with 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-compatible mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to view the values of Global system variables.Session level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle-compatible mode) or theinformation_schema.SESSION_VARIABLESview (MySQL-compatible mode) to view the values of Session system variables.
Modify variables
systenant can directly modify the values of Global system variables.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the values of Global system variables.Oracle user tenants must have the
ALTER SYSTEMprivilege to modify the values of Global system variables.
Attributes
| Attribute | Description |
|---|---|
| Type | Uint |
| Default value | 0, indicating no limit on the number of connections. |
| Value range | [0, 4294967295] |
| Scope |
|
| Modifiable | The value of this variable can be modified by using the SET GLOBAL statement. The value of this variable cannot be modified by using the ALTER SESSION SET statement. |
Examples
Set the maximum number of connections that a single user can establish with an OBServer node to be unlimited.
obclient> SET GLOBAL max_user_connections =0;