---
title: "ClickHouse® Settings"
sidebar_label: "Settings"
description: "How to change ClickHouse® settings"
sidebar_position: 8
---

import CircleAlert from '@selectel/docux/icons/circle-alert';
import Formbricks from '@theme/MDXComponents/Formbricks';

# ClickHouse® Settings

ClickHouse® settings affect the stability and performance of the database cluster. When [creating a cluster](/managed-databases/clickhouse/create-cluster.mdx), default values are applied in 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](#view-settings-list) and [change](#change-settings) 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 \{#view-settings-list}

You can view the list of settings available for changes when [creating a cluster](/managed-databases/clickhouse/create-cluster.mdx) or [changing settings](#change-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](https://clickhouse.com/docs/operations/settings) section of the ClickHouse® documentation.

1. In the [Dashboard](https://my.selectel.ru/vpc/default/dbaas/), 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 \{#change-settings}

:::danger

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 reboot automatically and will be unavailable during the reboot. The reboot will start immediately after the changes are saved. Settings that require a reboot are marked with the <CircleAlert /> icon.

1. In the [Dashboard](https://my.selectel.ru/vpc/default/dbaas/), 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.

<Formbricks />