Setup & maintenance
Learn how to set up, deploy, monitor, and backup ClickHouse with step-by-step guides.
AggregateFunction(uniq, UUID) doubled after ClickHouse upgrade
Page description for heading and indexes.
Can not connect to my ClickHouse server
Can not connect to my ClickHouse server.
cgroups and kubernetes cloud providers
cgroups and kubernetes cloud providers.
ClickHouse and different filesystems
ClickHouse and different filesystems.
Compatibility layer for clickhouse-operator metric exporter
Page description for heading and indexes.
How to convert uniqExact states to approximate uniq functions states
A way to convert to uniqExactState to other uniqStates (like uniqCombinedState) in Clickhouse.
Custom Settings
Using custom settings
Clickhouse data/disk encryption (at rest)
Example how to encrypt data in tables using storage policies.
Logging
Logging configuration and issues
Precreate parts using clickhouse-local
Precreate parts using clickhouse-local.
Access Control and Account Management (RBAC)
Access Control and Account Management (RBAC).
recovery-after-complete-data-loss
Recovery after complete data loss
source parts size is greater than the current maximum
source parts size (…) is greater than the current maximum (…)
Successful ClickHouse deployment plan
Successful ClickHouse deployment plan.
Timeouts during OPTIMIZE FINAL
Timeout exceeded ... or executing longer than distributed_ddl_task_timeout during OPTIMIZE FINAL.
Useful settings to turn on/Defaults that should be reconsidered
Useful settings to turn on.
Who ate my CPU
Queries to find which subsytem of Clickhouse is using the most of CPU.
ZooKeeper session has expired
ZooKeeper session has expired.
AWS EC2 Storage
AWS EBS, EFS, FSx, Lustre
clickhouse-backup
clickhouse-backup + backblaze
Server config files
How to manage server config files in Clickhouse
Suspiciously many broken parts
Suspiciously many broken parts error during the server startup.
Last modified 2022.02.18: Update _index.md (11a4a82)