v.24.10Improvement
Added max_parts_to_move setting for part movement control
Added a new setting max_parts_to_move to control the maximum number of parts that can be moved at once. #70520 (Vladimir Cherkasov).Why it matters
This setting helps control and manage resource usage and operational load by restricting the number of data parts moved at once, thereby improving stability and performance during merges or other background processes.How to use it
Users can enable or configure this feature by settingmax_parts_to_move to a desired integer value in the ClickHouse settings. For example, in the server configuration file or via SQL: SET max_parts_to_move = N;, where N is the maximum number of parts to move at once.