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

​

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