v.24.6New Feature

Added merge_workload and mutation_workload settings for resource regulation

Added merge_workload and mutation_workload settings to regulate how resources are utilized and shared between merges, mutations and other workloads. #64061 (Sergei Trifonov).
Introduced merge_workload and mutation_workload settings to control resource allocation between background merges, mutations, and other workload types in ClickHouse.

Why it matters

These new settings address the challenge of balancing resource usage among different internal operations, allowing users to better regulate how CPU and IO resources are distributed between merges, mutations, and other concurrent workloads. This helps optimize performance and prevents resource contention, improving overall system efficiency.

How to use it

Users can enable and configure resource sharing by setting merge_workload and mutation_workload parameters in their server or session configuration files. Adjust these settings according to workload priorities to fine-tune resource allocation between merges, mutations, and other queries.