Updated on 2023-07-06 GMT+08:00

Applying a Parameter Template

Scenarios

Modifications to parameters in a custom parameter template take effect only after you apply this parameter template to target DB instances.

  • 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 to which the parameter template applies, the maximum value within the range is used.
  • A parameter template can be applied only to DB instances of the same DB engine version.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
  4. On the Parameter Template Management 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 section Viewing Application Records of a Parameter Template.