Updated on 2023-12-28 GMT+08:00

Resetting a Parameter Template

Scenarios

You can reset all parameters in a custom parameter template to their default settings.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  3. On the Parameter Templates page, click Custom Templates. Locate the target parameter template and choose More > Reset in the Operation column.
  4. Click Yes.

  5. Apply the parameter template to your DB instance. For details, see Applying a Parameter Template.
  6. View the status of the DB instance to which the parameter template is applied.

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

    • The DB instance reboot caused by instance class changes will not make parameter modifications take effect.
    • If you have modified parameters of a primary DB instance, you need to reboot the primary DB instance for the modifications to take effect. (For primary/standby DB instances, the parameter modifications are also applied to the standby DB instance.)
    • If you have modified parameters of a read replica, you need to reboot the read replica for the modifications to take effect.