Help Center> GaussDB> User Guide> Instance Modifications> Modifying Instance Parameters
Updated on 2024-05-14 GMT+08:00
View PDF

Modifying Instance Parameters

You can view and modify the parameter values of a GaussDB instance.

GaussDB provides the following types of parameters:
  • Public parameters: GaussDB uses a set of default running parameters after it is installed. You can modify the parameters to better fit your application scenarios and data volume.
  • Parameters for data redistribution: These parameters are used to control the data redistribution policy during database scale-out.

Precautions

  • Parameters for data redistribution can be modified only for distributed instances of version 2.6 or later.
  • Parameters of read replicas can be modified only for primary/standby (1 primary + 2 standby) instances of version 2.7.1 or later.

Modifying Common Parameters

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.

  3. Click in the upper left corner of the page and choose Databases > GaussDB.
  4. On the Instances page, click the name of the target instance to go to the Basic Information page.
  5. In the navigation pane on the left, choose Parameters.

    • You can modify and query the parameters applied to the instance on this page. Click Preview to confirm the modifications or Cancel to cancel the modifications. After the modifications are confirmed, click Save.
      The modification of some parameters takes effect only after the instance is rebooted. After you modify a parameter value, view the value in the Effective upon Reboot column.
      • If the value is Yes and the instance status on the Instances page is Parameter change. Pending reboot, you must reboot the instance for the modifications to take effect.
      • If the value is No, the modifications take effect immediately for the instance.
    • You can click Replicate to save the parameters of the instance as a parameter template. You can view the parameter template under the Customer Templates tab of the Parameter Templates page. For details, see Parameter Template Management.
    • You can click Export to download the parameters of the instance to your local PC.
    • You can click Compare to compare the parameter template applied to the current instance with an existing parameter template.

Changing the Parameters for Data Redistribution

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.

  3. Click in the upper left corner of the page and choose Databases > GaussDB.
  4. On the Instances page, click the name of the target instance to go to the Basic Information page.
  5. In the navigation pane on the left, choose Parameters. On the displayed page, click Change Parameters for Scale-out or Change Parameters for Redistribution.

Parent topic: Instance Modifications