Skip to content

Instantly share code, notes, and snippets.

@den-crane
Created August 16, 2020 03:06
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save den-crane/4d67e1d4cc49de66cd36d1d76a2b14a5 to your computer and use it in GitHub Desktop.
Save den-crane/4d67e1d4cc49de66cd36d1d76a2b14a5 to your computer and use it in GitHub Desktop.
$ cat /etc/clickhouse-server/conf.d/clusters.xml
<?xml version="1.0" ?>
<yandex>
<remote_servers>
<xxx>
<shard>
<replica> <host>h1</host> <port>9000</port></replica>
</shard>
....
</xxx>
</remote_servers>
</yandex>
$ cat /etc/clickhouse-server/conf.d/macros.xml
<?xml version="1.0" ?>
<yandex/>
$ cat /etc/clickhouse-server/conf.d/macros.xml
<?xml version="1.0" ?>
<yandex/>
$ cat /etc/clickhouse-server/conf.d/memory_usage.xml
<?xml version="1.0" ?>
<yandex>
<profiles>
<default>
<max_memory_usage_for_all_queries>50659012608</max_memory_usage_for_all_queries>
<max_bytes_before_external_group_by>25329506304</max_bytes_before_external_group_by>
<max_memory_usage>50659012608</max_memory_usage>
</default>
</profiles>
</yandex>
cat /etc/clickhouse-server/conf.d/zookeeper.xml
<?xml version="1.0" ?>
<yandex>
<zookeeper>
<node>
<host>localhost</host> <port>2181</port>
</node>
</zookeeper>
<distributed_ddl>
<path>/clickhouse/testing/task_queue/ddl</path>
</distributed_ddl>
</yandex>
cat /etc/clickhouse-server/conf.d/z_parts_to_throw.xml
<yandex>
<merge_tree>
<parts_to_delay_insert>150</parts_to_delay_insert>
<parts_to_throw_insert>600</parts_to_throw_insert>
<max_delay_to_insert>5</max_delay_to_insert>
<enable_mixed_granularity_parts>1</enable_mixed_granularity_parts>
<index_granularity_bytes>10485760</index_granularity_bytes>
</merge_tree>
</yandex>
cat /etc/clickhouse-server/conf.d/user_default.xml
<?xml version="1.0" ?>
<yandex>
<users>
<default>
<networks>
<ip>::1</ip>
<ip>127.0.0.1</ip>
</networks>
</default>
</users>
</yandex>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment