cockroachdb / cockroachdb/cockroach

sql: TTL Job Maximum Execution Time Parameter

Open
#171,143 1 comment 0 reactions 0 assignees View on GitHub
A-row-level-ttl C-enhancement T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Today admins are unable to bound TTL job execution to a defined maintenance window. Not doing this means there is no guarantee that TTL operations will stop at the end of a scheduled window, risking uncontrolled impact to production workloads outside of approved maintenance periods.

Requesting to introduce per-table or cluster-level setting to cap TTL job execution time(ttl_max_runtime). When the limit is reached, the TTL job should stop cleanly and run again on the next scheduled run starting from where it left off. Default of ttl_max_runtime = 0 indicates there is no timelimit on TTL jobs. Any non-zero positive value (e.g. '2h', '4h') indicates the execution time limit.

Jira issue: CRDB-64335

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.