Manage Configuration Files
You can use the following details to manage the configure files.
Default Data Directory
/var/lib/clickhouseThis further includes:
| /var/lib/clickhouse/data/ | Actual table data files |
| /var/lib/clickhouse/metadata/ | Table metadata definitions (like schema) |
| /var/lib/clickhouse/store/ | (For Atomic DB engine) Table parts stored using UUIDs |
| /var/lib/clickhouse/tmp/ | Temporary files during merges/queries |
| /var/lib/clickhouse/flags/ | State flags for startup/shutdown |
| /var/lib/clickhouse/access/ | RBAC and user data (if enabled) |
You can view this mapping via:
SELECT database, name, uuid, data_paths FROM system.tables WHERE name = 'table_name';Set up Configuration Files
All ClickHouse configurations are stored in the following directory.
/etc/clickhouse/confAdditional subdirectories exist under this parent directory based on the configured services.
x
#All Server + WebServer service configuration files/etc/clickhouse/conf/server #All Keeper service configuration files/etc/clickhouse/conf/keeper#All Client required configuration files/etc/clickhouse/conf/clientClickHouse Server
ls -l /etc/clickhouse/conf/server/#Template for default config.xml-rw-r--r--. 1 clickhouse clickhouse 75497 Jul 6 07:57 config.xml#Directory to override configurations in config.xmldrwxr-xr-x. 2 clickhouse clickhouse 103 Jul 6 07:23 config.d#Template for default as initial user-rw-r--r--. 1 clickhouse clickhouse 7065 Jul 6 07:57 users.xmlls -l /etc/clickhouse/conf/server/config.d/# Containing shard and replica mapping for the present host-rw-r--r--. 1 clickhouse clickhouse 152 Jul 6 07:26 macros.xml#Containing network and logging configurable values-rw-r--r--. 1 clickhouse clickhouse 493 Jul 6 07:26 network-and-logging.xml#Containing cluster shard and replica mapping details with secrets and cluster names-rw-r--r--. 1 clickhouse clickhouse 432 Jul 6 07:26 remote-servers.xml#Containing details of Keeper quorum and reference to hostnames-rw-r--r--. 1 clickhouse clickhouse 190 Jul 6 07:26 use-keeper.xmlClickHouse WebServer
ls -l /etc/clickhouse/conf/server/#Application properties containing configuration for ClickHouse WEB UI-rw-r--r--. 1 clickhouse clickhouse 395 Jul 6 07:57 application.propertiesClickHouse Keeper
ls -l /etc/clickhouse/conf/keeper/#Template for keeper related configurations-rw-r--r--. 1 clickhouse clickhouse 3485 Jul 6 07:23 keeper_config.xml#Directory to override configurations in keeper_config.xmldrwxr-xr-x. 2 clickhouse clickhouse 62 Jul 6 07:21 keeper_config.d#Auto created files containg merged configurations from default and overriden-rw-r-----. 1 clickhouse clickhouse 4403 Jul 6 07:23 keeper_config-preprocessed.xmlls -l /etc/clickhouse/conf/keeper/keeper_config.d/#Containing Keeper related server and connection details with advanced settings-rw-r--r--. 1 clickhouse clickhouse 838 Jul 6 07:23 enable-keeper.xml#Containing network and logging configurable values (same as server)-rw-r--r--. 1 clickhouse clickhouse 493 Jul 6 07:23 network-and-logging.xmlClickHouse Client
ls -l /etc/clickhouse/conf/client/config.xml#Template for client config.xml-rw-r--r--. 1 clickhouse clickhouse 4859 Jul 6 07:20 /etc/clickhouse/conf/client/config.xmlFor more information about the ClickHouse configuration files, see Configuration Files.
Was this page helpful?