Note
This variable is available starting with V2.1.
Description
net_buffer_length specifies the maximum size of SQL queries that can be accepted by an OBServer node.
Privilege requirements
Query variables
Global level
The
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) and theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the values of global system variables.Session level
The
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode) and theinformation_schema.SESSION_VARIABLESview (MySQL mode) to view the values of session system variables.
Modify variables
The
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 | Int |
| Default value | 16384 |
| Value range | [1024, 1048576] |
| Scope |
|
| Modifiable | You can execute the SET GLOBAL statement to modify the value of this variable at the global level. You cannot execute the ALTER SESSION SET statement to modify the value of this variable at the session level. |
Examples
Set the maximum size of SQL queries that can be accepted by an OBServer node to 16384.
obclient> SET GLOBAL net_buffer_length =16384;