Help Center> GaussDB> User Guide> Parameter Template Management> Modifying GaussDB Instance Parameters in Batches
Updated on 2024-05-07 GMT+08:00

Modifying GaussDB Instance Parameters in Batches

You can modify parameters in a custom parameter template to bring out the best possible performance of a GaussDB instance.

You can change parameter values in custom parameter templates only and cannot change parameter values in default parameter templates.

The following are the key points you should know when using parameters in a parameter template:

  • To modify the parameters in a template of the current instance, go to the Parameters page, change parameter values and save the changes. Dynamic parameter changes take effect immediately, but static parameter changes take effect only after you manually reboot the instance.
  • To modify the parameters of a parameter template, go to the Parameter Templates page and under the Custom Templates tab, click the template name, change its parameter values and save the changes. Then, apply the changed parameter template to instances. The dynamic parameter changes take effect immediately, and the static parameter changes take effect only after you manually reboot the instances. For details about how to apply a parameter template to instances, see Applying a Parameter Template.

GaussDB has default parameter templates whose parameter values cannot be changed. You can view these parameter values by clicking the default parameter template names. If a custom parameter template is configured incorrectly and applied to instances, the instances maybe cannot be rebooted. If this happens, you can refer to the settings used by a default parameter template.

Procedure

  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. Choose Parameter Templates in the navigation pane on the left. On the Custom Templates page, click the parameter template name.
  5. Modify parameters as needed.

    Figure 1 Modifying a parameter
    • To save your changes, click Save. In the displayed dialog box, click Yes.
    • To cancel your changes, click Cancel.
    • To preview your changes, click Preview.

  6. After the parameters are modified, click Change History to view what changes have been made.

    The changes take effect only after you apply the parameter template to instances. For details, see Applying a Parameter Template.