Note
This variable is available starting with V2.2.77.
Description
sql_throttle_network specifies the request queuing time. If the queuing time is greater than or equal to this value, the query is not executed.
Privilege requirements
Query variables
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the value of Global system variables.Modify variables
systenants can directly modify the value of Global system variables.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the value of Global system variables.Oracle user tenants must have the
ALTER SYSTEMprivilege to modify the value of Global system variables.
Attributes
| Attribute | Description |
|---|---|
| Type | Numeric |
| Default value | -1 |
| Value range | Related to the system load, in us |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the request queuing time to 1000000 us.
obclient> SET GLOBAL sql_throttle_network = 1000000;