Help Center/ GaussDB(for MySQL)/ User Guide/ Parameter Template Management/ Modifying a Parameter Template
Updated on 2023-10-18 GMT+08:00
View PDF

Modifying a Parameter Template

To optimize GaussDB(for MySQL) database performance, you can change parameters in a custom parameter template and then apply the updated template to your instances.

You can change parameters in custom parameter templates, but cannot change parameters in default parameter templates.

The following are the key points you should know when using parameter templates:

  • To change the parameters in a parameter 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. This changes will apply only to the current instance. They will not affect other instances.
  • To change the parameters in a parameter template, go to the Parameter Templates page and under Custom Templates tab, click the template name, change its parameter values and save the changes. Then, apply the changed parameter template to instances. Dynamic parameter changes take effect immediately, but static parameter changes take effect only after you manually reboot the instances.

GaussDB(for MySQL) has default parameter templates whose parameters cannot be changed. You can view these parameters by clicking the default parameter templates. If a custom parameter template is configured incorrectly and applied into instances, the instances may be unable to be rebooted. If this happens, you can refer to the settings used by a default parameter template.

Modifying Parameter Template Parameters

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page, choose Database > GaussDB(for MySQL).
  4. In the navigation pane on the left, choose Parameter Templates. On the Custom Templates page, click the parameter template you want to change.
  5. Change parameters as needed.

    You can save, cancel, or preview your changes.

    After the value of the parameter log-bin is modified, the value of the database kernel parameter log-bin changes accordingly.

    Figure 1 Changing parameters in a parameter template
    • To save your changes, click Save.
    • To cancel your changes, click Cancel.
    • To preview your changes, click Preview.
      Figure 2 Previewing changes

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

Modifying Instance Parameters

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page, choose Database > GaussDB(for MySQL).
  4. On the Instances page, click the instance name to go to the Basic Information page.
  5. In the navigation pane on the left, choose Parameters. On the displayed page, change parameters if needed.

    You can save, cancel, or preview your changes.

    After you change instance parameters, check the value in the Effective upon Reboot column.
    • If Yes is displayed and the instance status on the Instances page is Parameter change. Pending reboot, you must reboot the instance for the changes to take effect.
    • If No is displayed, the changes take effect immediately for the current instance.
    • To save your changes, click Save.
    • To cancel your changes, click Cancel.
    • To preview your changes, click Preview.

    After parameters are changed, you can click Change History to view what changes have been made.