v.24.7Improvement

clickhouse-local now respects memory usage settings from configuration file

Official CH changelog text
clickhouse-local will respect the max_server_memory_usage and max_server_memory_usage_to_ram_ratio from the configuration file. It will also set the max memory usage to 90% of the system memory by default, like clickhouse-server does. #65697 (Alexey Milovidov).
clickhouse-local now respects max_server_memory_usage and max_server_memory_usage_to_ram_ratio settings from the configuration file and defaults to using 90% of system memory for max memory usage, aligning its behavior with clickhouse-server.

Why it matters

This feature ensures that clickhouse-local has consistent memory usage controls as clickhouse-server, preventing excessive memory consumption and improving stability by adhering to configured memory limits or a sensible default based on system RAM.

How to use it

Configure max_server_memory_usage and/or max_server_memory_usage_to_ram_ratio in the clickhouse-local configuration file. If unset, clickhouse-local will automatically limit its max memory usage to 90% of system RAM by default.

Related resources

PreviousNext