Note
This variable is available starting with V2.2.77.
Description
sql_throttle_priority specifies the throttling priority. Requests from sessions where the value of sql_throttle_current_priority is less than the value of sql_throttle_priority are throttled.
Privilege requirements
Query variables
The
systenant and all user tenants can query the value of a global system variable by using theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL mode).Modify variables
The
systenant can directly 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 | -1 |
| Value range | None. The actual value is related to the value of sql_throttle_current_priority. |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Usage
If the query priority is lower than this value, the query may be denied.
Examples
Set the throttling priority to 1.
obclient> SET GLOBAL sql_throttle_priority = 1;