v.24.2New Feature
Implement Auto-Adjustment for Asynchronous Insert Timeouts
Implement auto-adjustment for asynchronous insert timeouts. The following settings are introduced: async_insert_poll_timeout_ms, async_insert_use_adaptive_busy_timeout, async_insert_busy_timeout_min_ms, async_insert_busy_timeout_max_ms, async_insert_busy_timeout_increase_rate, async_insert_busy_timeout_decrease_rate. #58486 (Julia Kartseva).
Why it matters
This feature addresses scenarios where fixed asynchronous insert timeouts may be suboptimal by enabling adaptive timeout adjustments. It improves stability and performance during asynchronous inserts by automatically increasing or decreasing timeout intervals based on current system load and insert behavior.How to use it
Users can enable and configure auto-adjustment for async insert timeouts by setting the new parameters:async_insert_poll_timeout_ms, async_insert_use_adaptive_busy_timeout, async_insert_busy_timeout_min_ms, async_insert_busy_timeout_max_ms, async_insert_busy_timeout_increase_rate, and async_insert_busy_timeout_decrease_rate in their ClickHouse configuration files or session settings.