max_avg_part_size_for_too_many_parts
The ‘too many parts’ check according to ‘parts_to_delay_insert’ and ‘parts_to_throw_insert’ will be active only if the average part size (in the relevant partition) is not larger than the specified threshold. If it is larger than the specified threshold, the INSERTs will be neither delayed or rejected. This allows to have hundreds of terabytes in a single table on a single server if the parts are successfully merged to larger parts. This does not affect the thresholds on inactive parts or total parts.max_buckets_in_map
The maximum number of buckets forMap serialization. Works with with_buckets Map serialization.
The actual number of buckets is determined by map_buckets_strategy.
The maximum allowed value is 256.
max_cleanup_delay_period
Maximum period to clean old queue logs, blocks hashes and parts.max_compress_block_size
The maximum size of blocks of uncompressed data before compressing for writing to a table. You can also specify this setting in the global settings (see max_compress_block_size setting). The value specified when the table is created overrides the global value for this setting. For a column of fixed-size values the block size is rounded down to a multiple of the value size in bytes, but not below one value.max_concurrent_queries
Max number of concurrently executed queries related to the MergeTree table. Queries will still be limited by othermax_concurrent_queries settings.
Possible values:
- Positive integer.
0— No limit.
0 (no limit).
Example
max_digestion_size_per_segment
Obsolete setting, does nothing.max_file_name_length
The maximal length of the file name to keep it as is without hashing. Takes effect only if settingreplace_long_file_name_to_hash is enabled.
The value of this setting does not include the length of file extension. So,
it is recommended to set it below the maximum filename length (usually 255
bytes) with some gap to avoid filesystem errors.
max_partitions_to_read
Limits the maximum number of partitions that can be accessed in one query. The setting value specified when the table is created can be overridden via query-level setting. Possible values:- Any positive integer.
max_projections
The maximum number of merge tree projections.max_row_mask_update_coalescing_ast_bytes
Maximum sum of the original commands’ast_text bytes eligible for row-mask
update coalescing. The command-count limit alone cannot bound this copy when
commands contain large literals. Set to 0 to disable coalescing.
max_row_mask_update_coalescing_commands
Maximum number of part-local mutation commands eligible for row-mask update coalescing. This bounds the extra command-list copy made by the optimization; the value is a resource guard, not a semantic limit. Values below 2 disable coalescing.max_row_mask_update_coalescing_key_bytes
Maximum total number of key-literal bytes in one coalesced row-mask update. This bounds the size of the generatedIN predicate. Set to 0 to disable
coalescing.
max_row_mask_update_coalescing_keys
Maximum number of keys in one coalesced row-mask update. The effective limit also respectsmax_rows_in_set in the background query settings. Values below
2 disable coalescing.
max_table_size_bytes_compressed
If the total number of compressed bytes (the size on disk) across all active and inactive data parts of the table exceeds this value, anINSERT is
interrupted with the Table size limit exceeded exception. Inactive parts
are counted as well because the purpose of this setting is to limit disk
usage. Note that inactive parts are removed in the background (see the
old_parts_lifetime setting), so the observed size can decrease over time.
The limit is checked at the beginning of INSERT and when new data parts
are committed to the working set, including the results of background merges
and mutations. Inserts done by materialized views are also checked. The
limit is not checked on replicated fetches, which permits a race condition
when parallel inserts into multiple replicas overdraft the limit. Committing
empty data parts is always allowed, so the data can be removed from a table
that exceeds the limit, e.g. with TRUNCATE or ALTER TABLE ... DROP PARTITION.
Possible values:
- Any positive integer.
- 0 — unlimited.
max_table_size_bytes_uncompressed
The same asmax_table_size_bytes_compressed, but the limit is applied to
the total number of uncompressed bytes across all active and inactive data
parts of the table.
Possible values:
- Any positive integer.
- 0 — unlimited.
max_table_size_rows
If the total number of rows in active data parts of the table exceeds this value, anINSERT is interrupted with the Table size limit exceeded
exception. The limit is checked at the beginning of INSERT and when new
data parts are committed to the working set, including the results of
background merges and mutations (so a mutation that increases the table size
beyond the limit will be retried without finishing). Inserts done by
materialized views are also checked. The limit is not checked on replicated
fetches, which permits a race condition when parallel inserts into multiple
replicas overdraft the limit. Committing empty data parts is always allowed,
so the data can be removed from a table that exceeds the limit, e.g. with
TRUNCATE or ALTER TABLE ... DROP PARTITION.
Possible values:
- Any positive integer.
- 0 — unlimited.