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 and select a region and a project.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Parameter Templates page, click Custom Templates. Locate the target parameter template and choose More > Reset in the Operation column.
5. Click Yes.
   Figure 1 Confirming the reset
   

6. Apply the parameter template to your DB instance. For details, see Applying a Parameter Template.
7. 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.