Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

max_replicated_* MergeTree table settings

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

max_replicated_fetches_network_bandwidth

Type
UInt64
Default
0

Limits the maximum speed of data exchange over the network in bytes per second for replicated fetches. This setting is applied to a particular table, unlike the max_replicated_fetches_network_bandwidth_for_server setting, which is applied to the server.

You can limit both server network and network for a particular table, but for this the value of the table-level setting should be less than server-level one. Otherwise the server considers only the max_replicated_fetches_network_bandwidth_for_server setting.

The setting isn’t followed perfectly accurately.

Possible values:

  • Positive integer.
  • 0 — Unlimited.

Default value: 0.

Usage

Could be used for throttling speed when replicating data to add or replace new nodes.

max_replicated_logs_to_keep

Type
NonZeroUInt64
Default
1000

How many records may be in the ClickHouse Keeper log if there is inactive replica. An inactive replica becomes lost when when this number exceed.

Possible values:

  • Any positive integer.

max_replicated_merges_in_queue

Type
UInt64
Default
1000

How many tasks of merging and mutating parts are allowed simultaneously in ReplicatedMergeTree queue.

max_replicated_merges_with_ttl_in_queue

Type
UInt64
Default
1

How many tasks of merging parts with TTL are allowed simultaneously in ReplicatedMergeTree queue.

max_replicated_mutations_in_queue

Type
UInt64
Default
8

How many tasks of mutating parts are allowed simultaneously in ReplicatedMergeTree queue.

max_replicated_sends_network_bandwidth

Type
UInt64
Default
0

Limits the maximum speed of data exchange over the network in bytes per second for replicated sends. This setting is applied to a particular table, unlike the max_replicated_sends_network_bandwidth_for_server setting, which is applied to the server.

You can limit both server network and network for a particular table, but for this the value of the table-level setting should be less than server-level one. Otherwise the server considers only the max_replicated_sends_network_bandwidth_for_server setting.

The setting isn’t followed perfectly accurately.

Possible values:

  • Positive integer.
  • 0 — Unlimited.

Usage

Could be used for throttling speed when replicating data to add or replace new nodes.

Navigation