v.22.10Improvement
Allow Query-Scope Changes for async_insert_max_data_size and async_insert_busy_timeout_ms
Allow changingasync_insert_max_data_sizeorasync_insert_busy_timeout_msin scope of query. E.g. user wants to insert data rarely and she doesn't have access to the server config to tune default settings. #40668 (Nikita Mikhaylov).
Why it matters
This feature enables users who infrequently insert data and do not have access to server configuration to adjust the asynchronous insert behavior on a per-query basis, improving flexibility and control without requiring server-level changes.How to use it
Users can specify the settingsasync_insert_max_data_size and async_insert_busy_timeout_ms as query-level parameters to override the default server configuration during execution.