配置ck

This XML file does not appear to have any style information associated with it. The document tree is shown below.

1000M
10

 https://{bucket}.s3.amazonaws.com https://storage.googleapis.com/{bucket} https://{bucket}.oss.aliyuncs.com
Access-Control-Allow-Origin *
Access-Control-Allow-Headers origin, x-requested-with, x-clickhouse-format, x-clickhouse-user, x-clickhouse-key, Authorization
Access-Control-Allow-Methods POST, GET, OPTIONS
Access-Control-Max-Age 86400
8123 9000 9004 9005 9009 0.0.0.0 10000 10 false /path/to/ssl_cert_file /path/to/ssl_key_file false /path/to/ssl_ca_cert_file none 0 -1 -1 false none true true sslv2,sslv3 true RejectCertificateHandler true true sslv2,sslv3 true RejectCertificateHandler 0 2 10000 1000

<max_thread_pool_size>10000</max_thread_pool_size>

<async_load_databases>true</async_load_databases>

<max_server_memory_usage_to_ram_ratio>0.9</max_server_memory_usage_to_ram_ratio>

<total_memory_profiler_step>4194304</total_memory_profiler_step>

<total_memory_tracker_sample_probability>0</total_memory_tracker_sample_probability>

<max_open_files>262144</max_open_files>

<uncompressed_cache_size>8589934592</uncompressed_cache_size>

<mark_cache_size>5368709120</mark_cache_size>

<index_mark_cache_size>5368709120</index_mark_cache_size>

<mmap_cache_size>1000</mmap_cache_size>

<compiled_expression_cache_size>134217728</compiled_expression_cache_size>

<compiled_expression_cache_elements_size>10000</compiled_expression_cache_elements_size>

<custom_cached_disks_base_directory>/var/lib/clickhouse/caches/</custom_cached_disks_base_directory>
<validate_tcp_client_information>false</validate_tcp_client_information>

/var/lib/clickhouse/

<tmp_path>/var/lib/clickhouse/tmp/</tmp_path>

<allow_plaintext_password>1</allow_plaintext_password>
<allow_no_password>1</allow_no_password>
<allow_implicit_no_password>1</allow_implicit_no_password>

<default_password_type>sha256_password</default_password_type>

<bcrypt_workfactor>12</bcrypt_workfactor>

<user_files_path>/var/lib/clickhouse/user_files/</user_files_path>

<ldap_servers>

</ldap_servers>

<user_directories>
<users_xml>

users.xml
</users_xml>
<local_directory>

/var/lib/clickhouse/access/
</local_directory>

</user_directories>
<access_control_improvements>

<users_without_row_policies_can_read_rows>true</users_without_row_policies_can_read_rows>

<on_cluster_queries_require_cluster_grant>true</on_cluster_queries_require_cluster_grant>

<select_from_system_db_requires_grant>true</select_from_system_db_requires_grant>

<select_from_information_schema_requires_grant>true</select_from_information_schema_requires_grant>

<settings_constraints_replace_previous>true</settings_constraints_replace_previous>

<table_engines_require_grant>false</table_engines_require_grant>

<role_cache_expiration_time_seconds>600</role_cache_expiration_time_seconds>
</access_control_improvements>

<default_profile>default</default_profile>

<custom_settings_prefixes>SQL_</custom_settings_prefixes>

<default_database>default</default_database>

<mlock_executable>true</mlock_executable>

<remap_executable>false</remap_executable>

' | sed -e 's|.*>\(.*\)<.*|\1|') wget https://github.com/ClickHouse/clickhouse-jdbc-bridge/releases/download/v$PKG_VER/clickhouse-jdbc-bridge_$PKG_VER-1_all.deb apt install --no-install-recommends -f ./clickhouse-jdbc-bridge_$PKG_VER-1_all.deb clickhouse-jdbc-bridge & * [CentOS/RHEL] export MVN_URL=https://repo1.maven.org/maven2/com/clickhouse/clickhouse-jdbc-bridge/ export PKG_VER=$(curl -sL $MVN_URL/maven-metadata.xml | grep '' | sed -e 's|.*>\(.*\)<.*|\1|') wget https://github.com/ClickHouse/clickhouse-jdbc-bridge/releases/download/v$PKG_VER/clickhouse-jdbc-bridge-$PKG_VER-1.noarch.rpm yum localinstall -y clickhouse-jdbc-bridge-$PKG_VER-1.noarch.rpm clickhouse-jdbc-bridge & Please refer to https://github.com/ClickHouse/clickhouse-jdbc-bridge#usage for more information. ]]>

<remote_servers>
<sunseeker_cluster>

<internal_replication>true</internal_replication>

172.31.42.253
9000
default
Snk@2024!



<internal_replication>true</internal_replication>

172.31.43.26
9000
default
Snk@2024!



<internal_replication>true</internal_replication>

172.31.34.12
9000
default
Snk@2024!


</sunseeker_cluster>
</remote_servers>
<keeper_server>
<tcp_port>9181</tcp_port>
<server_id>1</server_id>
<log_storage_path>/var/lib/clickhouse/coordination/log</log_storage_path>
<snapshot_storage_path>/var/lib/clickhouse/coordination/snapshots</snapshot_storage_path>
<coordination_settings>
<operation_timeout_ms>20000</operation_timeout_ms>
<session_timeout_ms>30000</session_timeout_ms>
<raft_logs_level>warning</raft_logs_level>
</coordination_settings>
<raft_configuration>

1
172.31.42.253
9234


2
172.31.43.26
9234


3
172.31.34.12
9234

</raft_configuration>
</keeper_server>

172.31.42.253 9181 172.31.43.26 9181 172.31.34.12 9181

<builtin_dictionaries_reload_interval>3600</builtin_dictionaries_reload_interval>

<max_session_timeout>3600</max_session_timeout>

<default_session_timeout>60</default_session_timeout>

/metrics 9363 true true true system query_log
toYYYYMM(event_date)

event_date + INTERVAL 7 DAY DELETE
<flush_interval_milliseconds>7500</flush_interval_milliseconds>

<max_size_rows>1048576</max_size_rows>

<reserved_size_rows>8192</reserved_size_rows>

<buffer_size_rows_flush_threshold>524288</buffer_size_rows_flush_threshold>

<flush_on_crash>false</flush_on_crash>

</query_log>

<trace_log>
system

trace_log
event_date + INTERVAL 7 DAY DELETE toYYYYMM(event_date) 7500 1048576 8192 524288 false system query_thread_log
toYYYYMM(event_date) 7500 1048576 8192 524288 false system query_views_log
event_date + INTERVAL 7 DAY DELETE toYYYYMM(event_date) 7500 system part_log
toYYYYMM(event_date) event_date + INTERVAL 7 DAY DELETE 7500 1048576 8192 524288 false system metric_log
event_date + INTERVAL 7 DAY DELETE 7500 1048576 8192 524288 1000 false system asynchronous_metric_log
7000 1048576 8192 524288 false engine MergeTree partition by toYYYYMM(finish_date) order by (finish_date, finish_time_us, trace_id) system opentelemetry_span_log
7500 1048576 8192 524288 false system crash_log
1000 1024 1024 512 true

<processors_profile_log>
system

processors_profile_log
event_date + INTERVAL 7 DAY DELETE toYYYYMM(event_date) 7500 1048576 8192 524288 false system asynchronous_insert_log
event_date + INTERVAL 7 DAY DELETE 7500 1048576 8192 524288 false event_date event_date + INTERVAL 3 DAY system backup_log
toYYYYMM(event_date) event_date + INTERVAL 7 DAY DELETE 7500 system s3queue_log
toYYYYMM(event_date) event_date + INTERVAL 7 DAY DELETE 7500 system blob_storage_log
toYYYYMM(event_date) event_date + INTERVAL 7 DAY DELETE 7500 event_date + INTERVAL 30 DAY

</top_level_domains_lists>

<dictionaries_config>_dictionary.ml</dictionaries_config>

<dictionaries_lazy_load>true</dictionaries_lazy_load>

<wait_dictionaries_load_at_startup>true</wait_dictionaries_load_at_startup>

<user_defined_executable_functions_config>_function.ml</user_defined_executable_functions_config>

lz4 /clickhouse/task_queue/ddl 200000 click_cost any 0 3600 86400 60 max 0 60 3600 300 86400 3600 /var/lib/clickhouse/format_schemas/ /usr/share/clickhouse/protos/

false

false

https://6f33034cfe684dd7a3ab9875e57b1c8d@o388870.ingest.sentry.io/5226277

<send_logical_errors>false</send_logical_errors>
</send_crash_reports>

<query_cache>
<max_size_in_bytes>1073741824</max_size_in_bytes>
<max_entries>1024</max_entries>
<max_entry_size_in_bytes>1048576</max_entry_size_in_bytes>
<max_entry_size_in_rows>30000000</max_entry_size_in_rows>
</query_cache>

<allowed_path>backups</allowed_path>

<remove_backup_files_after_failure>true</remove_backup_files_after_failure>
posted @ 2025-08-18 14:40  kevinWwm  阅读(12)  评论(0)    收藏  举报