v.25.9Improvement

Make nice values of Linux threads configurable

Make nice values of Linux threads configurable to assign some threads (merge/mutate, query, materialized view, zookeeper client) higher or lower priorities. #86703 (Miсhael Stetsyuk).
Introduces configurable priority levels for specific Linux threads used by ClickHouse, enabling assignment of higher or lower priorities to threads such as merge/mutate, query, materialized view, and ZooKeeper client.

Why it matters

This feature allows users to optimize resource allocation and improve performance by adjusting the scheduling priority of important background and query threads. By configuring thread priorities, users can ensure critical operations receive appropriate system resources, enhancing overall system responsiveness and throughput.

How to use it

Users can configure thread priorities in the ClickHouse server configuration file by specifying priority values for different thread types (merge/mutate, query, materialized view, ZooKeeper client). This configuration adjusts the Linux thread nice values accordingly to influence thread scheduling.