Help Center/ TaurusDB/ User Guide/ Parameter Template Management/ Modifying Parameters of a DB Instance
Updated on 2025-03-28 GMT+08:00
View PDF

Modifying Parameters of a DB Instance

You can modify parameters of a DB instance to optimize performance if needed.

Modifying Parameters of a Single Instance

  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.
  5. In the navigation pane, choose Parameters. On the displayed page, modify parameters as required.

    After modifying the parameters, you can perform the following operations:
    • To save the modifications, click Save and then click Yes.
    • To cancel the modifications, click Cancel.
    • To preview the modifications, click Preview.
    • Dynamic parameter changes take effect immediately, but static parameter changes take effect only after you manually reboot the instance. After you modify a parameter value, check the value in the Effective upon Reboot column. You are advised to reboot the instance during off-peak hours and ensure that your applications support automatic reconnection.

  6. After the parameters are modified, click Change History to view the modification records.

Modifying Parameters in a Parameter Template

  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, choose Parameter Templates.
  5. On the Custom Templates tab, click the parameter template name.
  6. On the displayed Parameters page, modify parameters as required.

    After modifying the parameters, you can perform the following operations:

    • To save the modifications, click Save and then click Yes.
    • To cancel the modifications, click Cancel.
    • To preview the modifications, click Preview.
    • Dynamic parameter changes take effect immediately, but static parameter changes take effect only after you manually reboot the instance. After you modify a parameter value, check the value in the Effective upon Reboot column. You are advised to reboot the instance during off-peak hours and ensure that your applications support automatic reconnection.

  7. Choose Change History in the navigation pane to view the changes.
  8. Apply the parameter template to your DB instance. For details, see Applying a Parameter Template.
  9. View the status of the DB instance to which the parameter template was applied.

    If the DB instance status is Parameter change. Pending reboot, a reboot is required for the modifications to take effect.