mutations_* session settings

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

mutations_max_literal_size_to_replace

The maximum size of serialized literal in bytes to replace in UPDATE and DELETE queries. Takes effect only if at least one the two settings above is enabled. Default value: 16384 (16 KiB).

mutations_sync

Value	Description
`0`	Mutations execute asynchronously.
`1`	The query waits for all mutations to complete on the current server.
`2`	The query waits for all mutations to complete on all replicas (if they exist).
`3`	The query waits only for active replicas. Supported only for `SharedMergeTree`. For `ReplicatedMergeTree` it behaves the same as `mutations_sync = 2`.

SQL Reference

Data Types

Engines

Functions

Formats

Settings

System Tables

Data Lakes

mutations_max_literal_size_to_replace

mutations_sync

​mutations_max_literal_size_to_replace

​mutations_sync

mutations_max_literal_size_to_replace

mutations_sync