Setup & maintenance
Learn how to set up, deploy, monitor, and backup ClickHouse® with step-by-step guides.
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.
ClickHouse® Access Control and Account Management (RBAC)
Access Control and Account Management (RBAC).
Compatibility layer for the Altinity Kubernetes Operator for ClickHouse®
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.
How to recreate a table in case of total corruption of the replication queue
How to recreate a table in case of total corruption of the replication queue.
Logging
Logging configuration and issues
Precreate parts using clickhouse-local
Precreate parts using clickhouse-local.
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 (…)
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.
Altinity Backup for ClickHouse®
Altinity Backup for ClickHouse® + backblaze
AWS EC2 Storage
AWS EBS, EFS, FSx, Lustre
Memory Overcommiter
Enable Memory overcommiter instead of ussing max_memory_usage per query
Moving a table to another device
Moving a table to another device.
Replication and DDL queue problems
This article describes how to detect possible problems in the replication_queue and distributed_ddl_queue and how to troubleshoot.
Server config files
How to manage server config files in ClickHouse®
Suspiciously many broken parts
Suspiciously many broken parts error during the server startup.