Help Center/ GaussDB(DWS)/ More Documents/ User Guide (Paris Region)/ Cluster Management/ Modifying Database Parameters
Updated on 2024-06-11 GMT+08:00
View PDF
Share

Modifying Database Parameters

After a cluster is created, you can modify the cluster's database parameters as required. On the GaussDB(DWS) management console, you can configure common database parameters. For details, see Modifying Parameters. You can also view the parameter modification history. For details, see Viewing Parameter Change History. You can run SQL commands to view or set other database parameters. For details, see Setting Configuration Parameters in the Data Warehouse Service Database Development Guide.

Prerequisites

You can modify parameters only when no task is running in the cluster.

Modifying Parameters

  1. Log in to the GaussDB(DWS) management console.
  2. In the navigation pane on the left, choose Clusters > Dedicated Clusters.
  3. In the cluster list, find the target cluster and click the cluster name. The Cluster Information page is displayed.
  4. Click the Parameters tab and modify the parameter values. Then click Save.

  5. In the Modification Preview dialog box, confirm the modifications and click Save.
  6. You can determine whether you need to restart the cluster after parameter modification based on the Restart Cluster column.

    • If cluster restart is not required for a parameter, the parameter modification takes effect immediately.
    • If cluster restart is required for parameter modifications to take effect, the new parameter values will be displayed on the page after the modification, but will not take effect until the cluster is restarted.Before a restart, the cluster status is To be restarted, and some O&M operations are disabled.

Viewing Parameter Change History

Perform the following steps to view the parameter modification history and check whether the modifications have taken effect:

Procedure

  1. Log in to the GaussDB(DWS) management console.
  2. In the navigation pane on the left, choose Clusters > Dedicated Clusters.
  3. In the cluster list, find the target cluster and click the cluster name. The Cluster Information page is displayed.
  4. Click the Modify Records tab.

    • If a parameter can take effect immediately after modification, its status will change to Synchronized after you modify it.
    • If a parameter can take effect only after a cluster restart, its status will change to To be restarted after you modify it. You can click the expansion icon on the left to view the parameters that have not taken effect. After the cluster is restarted, the status of the record will change to Synchronized.

  5. By default, only the change history within a specified period is displayed. To check the entire change history of a parameter, search for it in the search box in the upper right corner.

Parameter Description

The following table describes part of the database parameters. You can search for and check more parameters by following the instructions in Modifying Parameters.

The default values of the following parameters are for reference only. For more information, see "Setting GUC Parameters".

Parent topic: Cluster Management