ApsaraDB RDS:Modify instance parameters

Modify a single parameter

1. On the Modifiable Parameters tab, find the parameter that you want to modify and change its value based on your business requirements.

   • In the Running Value column, click the icon. In the dialog box that appears, enter the new value based on the value range of the parameter.

   • Select a parameter value from the drop-down list in the Running Value column.

2. Click OK.

3. Click Apply Changes. In the dialog box that appears, select the time range during which you want the new parameter settings to take effect. You can select Take Effect Immediately, Take Effect Within Maintenance Window, or Take Effect at Specified Time.

4. Optional. If you want to revoke the modifications before you apply the new parameter values, click Cancel Changes.

Apply and export a parameter template

Apply a parameter template to instances

The system provides various system parameter templates to meet the requirements of different business scenarios, such as scenarios in which you require high performance. You can also create custom parameter templates to configure multiple parameters at a time. For more information, see Use a parameter template.

1. On the Modifiable Parameters tab, click Apply Template.

2. In the Apply Template dialog box, select the parameter template that you want to use and click OK.

   Note

   • You can view the number of parameters in the parameter template and check whether you must restart the RDS instance for the new values of the parameters to take effect. You can also click View Parameter Change to view the changes in the values of the parameters in the parameter template.

   • If you cannot find the parameter template that you want to use, you must check whether the parameter template resides in the same region as the RDS instance. If the parameter template and the RDS instance reside in different regions, you can replicate the parameter template to the region where the RDS instance resides. For more information, see Use a parameter template.

Export Parameter Template

1. On the Modifiable Parameters tab, click Export as Template.

2. Configure the following parameters.

   Parameter	Description
   Template Name	Enter a template name. The name must be 8 to 64 characters in length and can contain letters, digits, dots (.), and underscores (_). The name must start with a letter.
   Description	Enter a description for the parameter template. The description can be up to 200 characters in length.

3. Click OK. A parameter template is created in the region.

Import and export parameters in the TXT format

If you want to modify a large number of parameters or obtain instance parameter configurations, you can export a parameter file in the TXT format to your computer. The TXT file contains all parameter values of the RDS instance. After you modify the parameters, you can import the file to the RDS instance to apply the parameter changes.

1. Click Export Parameters to export the parameter file in the TXT format to your computer.

2. Modify the required parameters in the file, click Import Parameters, and then paste the file content to the dialog box.

3. Click OK.

4. Click Apply Changes. In the dialog box that appears, select the time range during which you want the new parameter settings to take effect. You can select Take Effect Immediately, Take Effect Within Maintenance Window, or Take Effect at Specified Time.

5. Optional. Before the new parameter values are applied, you can click Cancel Changes to revoke the changes.

   Important

   If an error message that indicates invalid parameter formats appears, you must check whether the new parameter value is within the value range of the parameter.