v.23.6Improvement

Settings number_of_mutations_to_delay and number_of_mutations_to_throw Enabled by Default with New Values

Settings number_of_mutations_to_delay and number_of_mutations_to_throw are enabled by default now with values 500 and 1000 respectively. #50726 (Anton Popov).
The settings number_of_mutations_to_delay and number_of_mutations_to_throw are now enabled by default with values 500 and 1000 respectively.

Why it matters

These settings help to control the number of pending mutations in ClickHouse, improving system stability by delaying or throwing exceptions when too many mutations accumulate. Enabling them by default helps prevent excessive mutation queues that could degrade performance or cause operational issues.

How to use it

These settings are enabled by default and can be configured in the ClickHouse server settings. Users can adjust number_of_mutations_to_delay and number_of_mutations_to_throw to tune the mutation handling thresholds as needed.