Applying a Parameter Template

Precautions

• The parameter innodb_buffer_pool_size is determined by the memory. Instances of different specifications have different value ranges. If this parameter value is out of range of the instance to which the parameter template is applied, the maximum value within the range is used.
• A parameter template can be applied only to 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 project.
3. Click in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
4. On the Parameter Templates page, apply a default template or a custom template to DB instances.
   • To apply a default template, click Default Templates, locate a parameter template and click Apply in the Operation column.
     Figure 1 Applying a default parameter template to DB instances
     

   • To apply a custom template, click Custom Templates, locate a parameter template and choose More > Apply in the Operation column.
     Figure 2 Applying a custom parameter template to DB instances
     

5. In the displayed Apply Parameter Template dialog box, select DB instances and click OK.
6. After the parameter template is applied, view the name or ID of the DB instance to which the parameter template is applied, application status, application time, and failure cause.
   • On the Default Templates tab, locate the parameter template and click View Application Record in the Operation column.
   • On the Custom Templates tab, locate the parameter template and choose More > View Application Record in the Operation column.

APIs

Applying a Parameter Template