v.23.8Improvement

Dynamic Runtime Configuration of Cache Sizes in ClickHouse

Official CH changelog text
The sizes of the (index) uncompressed/mark, mmap and query caches can now be configured dynamically at runtime (without server restart). #51446 (Robert Schulze).
The sizes of the (index) uncompressed/mark, mmap, and query caches in ClickHouse can now be configured dynamically at runtime without needing to restart the server.

Why it matters

This feature allows users to adjust cache sizes on-the-fly to optimize resource utilization and query performance without incurring downtime due to server restarts, improving operational flexibility and responsiveness.

How to use it

Use the new runtime configuration options to set or modify the cache sizes dynamically. Changes take effect immediately without restarting the ClickHouse server.

Related resources

PreviousNext