Note
This parameter is available starting with V3.1.4.
Description
kv_ttl_history_recycle_interval specifies the time period for which TTL task history records are retained. The history records table of the TTL task only retains records for the most recent period specified by kv_ttl_history_recycle_interval.
Privilege requirements
Query the parameter
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Time |
| Default value | 7d |
| Value range | [1d, 180d] |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Examples
Set the time period for which TTL task history records are retained to 7d.
obclient> ALTER SYSTEM SET kv_ttl_history_recycle_interval= '7d';