Note
This variable is available starting with V2.1.
Description
sql_throttle_rt specifies the RT value in microseconds. If the RT value of a query is not less than this value, the query is not allowed to be executed.
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 view 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 | Numeric |
| Default value | -1 |
| Value range | No value range. It is related to the actual business load. |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the RT value of queries to 100 us.
obclient> SET GLOBAL sql_throttle_rt = 100;