v.21.2Improvements

Allow max_server_memory_usage change without restart

Allow change max_server_memory_usage without restart. This closes #18154. #19186 (alexey-milovidov).
Allow changing the max_server_memory_usage setting dynamically without requiring a server restart.

Why it matters

This feature enables administrators to adjust the maximum server memory usage limit on-the-fly, improving server manageability and flexibility. It eliminates downtime caused by restarts when tuning memory usage parameters, thus enhancing operational efficiency and resource optimization.

How to use it

Users can modify the max_server_memory_usage setting dynamically via the server configuration or administrative interfaces without restarting the ClickHouse server. The change will take effect immediately, allowing for seamless adjustment of memory usage limits.