Note
This variable is available starting with V2.1.
Description
net_buffer_length specifies the maximum size of an SQL query that can be accepted by an OBServer node.
Privilege requirements
Query variables
Global level
The
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 value of a global system variable.Session level
The
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 value of a session system variable.
Modify variables
The
systenant can modify the value of a global system variable.A MySQL user tenant must have the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.An Oracle user tenant must have the
ALTER SYSTEMprivilege to modify the value of a global system variable.
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 in Global mode. You cannot execute the ALTER SESSION SET statement to modify the value of this variable in Session mode. |
Examples
Set the maximum size of an SQL query that can be accepted by an OBServer node to 16384.
obclient> SET GLOBAL net_buffer_length =16384;