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_select_as_async_insert

Whether a user-initiated INSERT ... SELECT may use the asynchronous insert queue when async_insert is enabled and the query is eligible (a single small block into a MergeTree-family destination with no dependent views). When disabled, INSERT ... SELECT always runs synchronously regardless of async_insert. Internal inserts (refreshable materialized view, POPULATE, CREATE TABLE ... AS SELECT) are always synchronous and ignore this setting.

​

async_insert_use_adaptive_busy_timeout

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