Set up docs MCPThese settings are available in system.settings and are autogenerated from source.
mutations_max_literal_size_to_replace
Type
UInt64
Default
16384
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
Type
UInt64
Default
0
Allows to execute ALTER TABLE ... UPDATE|DELETE|MATERIALIZE INDEX|MATERIALIZE PROJECTION|MATERIALIZE COLUMN|MATERIALIZE STATISTICS queries (mutations) synchronously.
Possible values:
| 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. |