This topic describes how to use the console or API to view and reconfigure some parameters for an RDS for MySQL instance. You can also use the console to query the parameter reconfiguration history.

Precautions

  • When you reconfigure parameters on the Parameters page, see the Value Range column corresponding to each parameter.
  • After you reconfigure certain parameters, you must restart the RDS instance for the changes to take effect. For more information, see the Restart column on the Parameters page. A restart disconnects the RDS instance. We recommend that you make appropriate service arrangements before you restart an RDS instance. Proceed with caution.

Reconfigure parameters

If you want to reconfigure the parameters of an RDS instance in batches, we recommend that you use a parameter template.

  1. Log on to the RDS console.
  2. Select the target region.
    选择地域
  3. Find the target RDS instance and click the instance ID.
  4. In the left-side navigation pane, click Parameters.
    参数设置
  5. On the Modifiable Parameters tab, reconfigure one or more parameters as needed.
    To apply a parameter template to the RDS instance, follow these steps:
    Note If applying the parameter template requires a restart, we recommend that you perform the operation during off-peak hours and make sure that your application can automatically reconnect to the RDS instance.
    1. Click Apply Template.
    2. In the Apply Template dialog box, select the parameter template you want to apply, and click OK.
      Note
      • You can view the number of parameters in the template and whether the template requires a restart. For more information about the parameter changes, click View Parameter Change.
      • If you cannot find the template, check whether the template is in the same region as the RDS instance. If they are in different regions, you can replicate the template to the region where the RDS instance is located. For more information, see Operate parameter templates.
      应用模板
    To export the parameter settings of the RDS instance as a parameter template, follow these steps:
    1. Click Export as Template.
    2. Set the following parameters.
      Parameter Description
      Template Name The name of the parameter template. The template name must start with a letter and can contain 8 to 64 characters including letters, digits, decimal points (.), and underscores (_).
      Description The description of the parameter template for easy template management. The description can contain up to 200 characters.
      导出为模板
    3. Click OK.
    To export the parameters of the RDS instance, follow these steps:

    Click Export Parameters. The parameters are exported as a file in TXT format to your computer. The file contains all the parameters and their settings of the RDS instance.

    To import the parameters of the RDS instance, follow these steps:
    1. After you finish modifying the exported parameter file, click Import Parameters and copy the content of the parameter file to the Import Parameters dialog box.
    2. Click OK.
    3. In the upper-right corner, click Apply Changes.
      Note
      • If the new parameter settings take effect only after the RDS instance is restarted, the system asks you whether you want to restart the RDS instance. If so, we recommend that you reconfigure parameters during off-peak hours and make sure that your application can automatically reconnect to the RDS instance.
      • Before the new parameter settings take effect, you can click Cancel Changes to cancel the parameter reconfiguration.
      提交参数
    To reconfigure only one parameter of the RDS instance, follow these steps:
    1. On the Modifiable Parameters tab, find the parameter you want to reconfigure, and in the Actual Value column click 参数值修改按钮.
    2. In the displayed dialog box, enter a new value within the value range.
      修改参数值
    3. Click Confirm.
    4. In the upper-right corner, click Apply Parameters.
      Note
      • If the new parameter settings take effect only after the RDS instance is restarted, the system asks you whether you want to restart the RDS instance. If so, we recommend that you reconfigure parameters during off-peak hours and make sure that your application can automatically reconnect to the RDS instance.
      • Before the new parameter settings take effect, you can click Cancel Changes to cancel the parameter reconfiguration.

View the parameter reconfiguration history

  1. Log on to the RDS console.
  2. Select the target region.
    选择地域
  3. Find the target RDS instance and click the instance ID.
  4. In the left-side navigation pane, click Parameters.
  5. Click the Modification History tab.
  6. Select a time range and click Search.
    查询参数修改历史