Help Center/ GaussDB(DWS)/ Management Guide/ Cluster Management/ Modifying Database Parameters
Updated on 2024-09-05 GMT+08:00
View PDF

Modifying Database Parameters

After a cluster is created, you can modify the cluster's database parameters as required. On the GaussDB(DWS) 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. Click Export to export all parameter settings of the cluster. You can run SQL commands to view or set other database parameters. For details, see Configuring GUC Parameters.

Prerequisites

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

Modifying Parameters

  1. Log in to the GaussDB(DWS) 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) 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

There are a large number of database parameters. You can search for and view the parameters on the Parameter Modification page. For details, see Modifying Parameters. The default values of the parameters are for reference only. For more information, see Setting GUC Parameters.

Parent topic: Cluster Management