Overview
max_user_connections specifies the maximum number of connections a single user can establish to an OBServer node.
Privilege requirements
Query variables
Global level
Both the
systenant and all user tenants can use theSHOW VARIABLESstatement and theinformation_schema.GLOBAL_VARIABLESview to view the values of global system variables.Session level
The
systenant and all user tenants can use theSHOW VARIABLESstatement and theinformation_schema.SESSION_VARIABLESview to view the values of session system variables.
Modify variables
The
systenant can directly modify the values of global system variables.The user tenant must have the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Uint |
| Default Value | 0 indicates that the number of connections is not limited. |
| Value range | [0, 4294967295] |
| Effective Scope |
|
| Modifiable | This variable can be obtained through theSET GLOBALThe value obtained by modifying the global effective method cannot be obtained throughALTER SESSION SETstatement modifies the value under the session effective mode. |
Configuration example
Set the number of connections that a single user can establish to an OBServer node to unlimited.
obclient> SET GLOBAL max_user_connections =0;