Skip to main content

ClickHouse® Settings

Last update:

ClickHouse® settings affect the stability and performance of the database cluster. When creating a cluster, default values are applied to the settings. These defaults are optimized for high performance and vary depending on the cluster configuration.

You can:

  • view the default settings and change them when creating a cluster;
  • or view the settings and change them in an already created cluster.

We recommend changing settings only when necessary—incorrect values can render the cluster inoperable or reduce its performance.

View the list of settings

You can view the list of settings available for changes when creating a cluster or changing settings.

If you have changed settings, you can view a separate list of settings that differ from the default values.

A detailed description of all settings can be found in the Settings section of the ClickHouse® documentation.

  1. In the Dashboard, on the top menu, click Products and select Managed Databases.
  2. Open the Active tab.
  3. Open the cluster page → Settings tab.
  4. In the DBMS Settings block, click Edit.
  5. Optional: to view only the settings for which you have changed the default value, select the Show changed parameters checkbox.
  6. View the settings.

Change settings

carefully

We recommend changing settings only when necessary—incorrect values can render the cluster inoperable or reduce its performance.

After changing some settings, the cluster will automatically restart and be unavailable during the restart process. The restart will begin immediately after you save your changes. Settings that require a restart are marked with a .

  1. In the Dashboard, on the top menu, click Products and select Managed Databases.
  2. Open the Active tab.
  3. Open the cluster page → Settings tab.
  4. In the DBMS Settings block, click Edit.
  5. Specify the new values.
  6. Click Save.

ClickHouse® is a registered trademark of ClickHouse, Inc. https://clickhouse.com.