Overview
net_buffer_length specifies the maximum size of an SQL query that an OBServer node can accept.
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 | Int |
| Default Value | 16384 |
| Value range | [1024, 1048576] |
| Effective Scope |
|
| Modifiable | This variable can be obtained through theSET GLOBALThe value under the global effective mode cannot be modified by using theALTER SESSION SETstatement modifies the value under the session effective mode. |
Configuration example
Set the maximum SQL query size that an OBServer node can accept to 16,384.
obclient> SET GLOBAL net_buffer_length =16384;