async_insert_* session settings

These settings are available in system.settings and are autogenerated from source.

async_insert

If true, data from INSERT query is stored in queue and later flushed to table in background. If wait_for_async_insert is false, INSERT query is processed almost instantly, otherwise client will wait until data will be flushed to table

async_insert_busy_timeout_decrease_rate

The exponential growth rate at which the adaptive asynchronous insert timeout decreases

async_insert_busy_timeout_increase_rate

The exponential growth rate at which the adaptive asynchronous insert timeout increases

async_insert_busy_timeout_max_ms

Aliases: async_insert_busy_timeout_ms

Maximum time to wait before dumping collected data per query since the first data appeared.

Cloud default value: 1000 (1s).

async_insert_busy_timeout_min_ms

If auto-adjusting is enabled through async_insert_use_adaptive_busy_timeout, minimum time to wait before dumping collected data per query since the first data appeared. It also serves as the initial value for the adaptive algorithm

async_insert_deduplicate

For async INSERT queries in the replicated table, specifies that deduplication of inserting blocks should be performed.

This setting only takes effect when deduplicate_insert is set to backward_compatible_choice.

async_insert_max_data_size

Maximum size in bytes of unparsed data collected per query before being inserted

Cloud default value: 104857600 (100 MiB).

async_insert_max_query_number

Maximum number of insert queries before being inserted. Only takes effect if setting async_insert_deduplicate is 1.

async_insert_poll_timeout_ms

Timeout for polling data from asynchronous insert queue

async_insert_use_adaptive_busy_timeout

If it is set to true, use adaptive busy timeout for asynchronous inserts