Applying a Parameter Template

Scenarios

You can apply parameter templates to DB instances as needed.

• The parameter innodb_buffer_pool_size is determined by the memory. DB instances of different specifications have different value ranges. If this parameter value is out of range of the DB instance that the parameter template applies to, the maximum value within the range is used.
• A parameter template can be applied only to DB instances of the same DB engine version.
• After a default parameter template is applied to an instance, all parameters in the instance are changed to be the same as those in the default parameter template, and all specification parameters are reset based on the instance specifications.

Applying a Parameter Template

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Parameter Templates page, perform the following operations based on the type of the parameter template to be applied:
   • If you intend to apply a default parameter template to DB instances, click Default Templates, locate the target parameter template, and click Apply in the Operation column.
   • If you intend to apply a custom parameter template to DB instances, click Custom Templates, locate the target parameter template, and choose More > Apply in the Operation column.

   A parameter template can be applied to one or more DB instances.

5. In the displayed dialog box, select one or more DB instances to which the parameter template will be applied and click OK.

   After the parameter template is successfully applied, you can view the application records by referring to Viewing Application Records of a Parameter Template.

Viewing Application Records of a Parameter Template

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. Choose Parameter Templates in the navigation pane on the left.
5. On the Default Templates or Custom Templates page, locate the target parameter template and choose More > View Application Record in the Operation column.

   You can view the name or ID of the DB instance that the parameter template applies to, as well as the application status, application time, and failure cause (if failed).

   Figure 1 Viewing application records of a parameter template