Note
This variable is available starting with V2.2.77.
Description
sql_throttle_priority specifies the throttling priority. Only requests from sessions whose sql_throttle_current_priority is less than sql_throttle_priority are throttled.
Privilege requirements
Query variables
systenants 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 obtain the values of global system variables.Modify variables
systenants 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 | -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;