v.22.9Improvement

Add TTL Support in EmbeddedRocksDB

Official CH changelog text
Add support for TTL in EmbeddedRocksDB. #39986 (Lloyd-Pottiger).
Add support for TTL (Time To Live) in EmbeddedRocksDB, enabling automatic expiration and removal of outdated data within the embedded RocksDB storage engine.

Why it matters

This feature allows users to automatically manage data lifecycle by specifying TTL for data stored in EmbeddedRocksDB. It solves the problem of manually cleaning up stale or expired data, improving storage efficiency and reducing maintenance overhead.

How to use it

Users can enable TTL by configuring expiration settings in the EmbeddedRocksDB tables. TTL parameters can be set using appropriate table settings or schemas that define the time after which data should expire and be removed automatically.

Related resources

PreviousNext