sql_throttle_priority

Description

sql_throttle_priority specifies the throttling priority. Requests from sessions whose sql_throttle_current_priority is less than sql_throttle_priority are throttled.

Privilege requirements

• Query variables

  sys tenants and all user tenants can query the value of global system variables by using the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view in Oracle mode or the information_schema.GLOBAL_VARIABLES view in MySQL mode.

• Modify variables

  • sys tenants can directly modify the value of global system variables.

  • MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the value of global system variables.

  • Oracle user tenants must have the ALTER SYSTEM privilege to modify the value of global system variables.

Attributes

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;