Manage Configuration Files

You can use the following details to manage the configuration files.

Default Data Directory

_var_lib_clickhouse

This 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_conf

Additional subdirectories exist under this parent directory based on the configured services.

#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_client

ClickHouse 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.xml drwxr-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.xml ls -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.xml

ClickHouse 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.properties

ClickHouse 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.xml drwxr-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.xml ls -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.xml

ClickHouse 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.xml

For more information about the ClickHouse configuration files, see Configuration Files.

Last updated on Nov 7, 2025

Was this page helpful?