Description
The sql_throttle_priority variable specifies the throttling priority. Only requests on sessions whose sql_throttle_current_priority variable value is lower than the value of this variable are throttled.
Privilege requirements
Query variables
systenants and all user tenants can execute theSHOW VARIABLESstatement or view theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLE(Oracle mode) orinformation_schema.GLOBAL_VARIABLES(MySQL mode) view to query the value of a global system variable.Modify variables
systenants can directly modify the value of a global system variable.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.For V4.x, starting from V4.2.0, Oracle user tenants must have the
ALTER SYSTEMprivilege to modify the value of a global system variable.
Attributes
| Attribute | Description |
|---|---|
| Type | int |
| Default value | -1 |
| Value range | No value range. The actual value range depends on the value of the sql_throttle_current_priority variable. |
| Effective scope | GLOBAL |
Note
If the query priority is lower than this value, the query may be blocked.