v.21.1Improvements

Allow TTL Specification for System Log Table Entry Removal

Official CH changelog text
Allow specifying TTL to remove old entries from system log tables, using the <ttl> attribute in config.xml. #17438 (Du Chuan).
Allows specifying TTL rules to automatically remove old entries from system log tables in ClickHouse using the <ttl> attribute in config.xml.

Why it matters

This feature enables automatic data retention management for system log tables by purging outdated entries, helping to control storage usage and maintain system performance without manual intervention.

How to use it

Define the <ttl> attribute with the desired TTL expression inside the config.xml configuration file to specify how long entries in system log tables should be retained before being removed.

Related resources

PreviousNext