Overview
kv_ttl_delete_max_ops specifies the maximum number of operations allowed for a TTL task. This parameter helps to throttle the rate at which a TTL task can delete records, thereby preventing performance degradation caused by excessive deletion operations.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Both the
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default Value | 0 indicates that there is no speed limit. |
| Value range | [0, +∞), which indicates the maximum number of delete operations allowed for a TTL task per second. |
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Configuration example
Set the maximum number of deletions allowed per second for the TTL task to 1000.
ALTER SYSTEM SET kv_ttl_delete_max_ops = 1000;