This topic describes how to view and reconfigure the parameters of an ApsaraDB RDS for MySQL instance by using the ApsaraDB for RDS console or the API. You can also view the parameter reconfiguration history in the ApsaraDB for RDS console.

Precautions

  • To ensure instance stability, the ApsaraDB for RDS console allows you to reconfigure only some parameters. If you cannot find the parameter that you want to reconfigure, submit a ticket.
  • When you reconfigure parameters, you can refer to the Value Range column on the Editable Parameters tab in the ApsaraDB for RDS console.
  • The new values of some parameters can take effect only after an instance restart. For more information, refer to the Force Restart column on the Editable Parameters tab in the ApsaraDB for RDS console. We recommend that you reconfigure parameters during off-peak hours and make sure that your application is configured to automatically reconnect to your RDS instance.

Reconfigure parameters

Note If you want to reconfigure a number of parameters at a time, we recommend that you use a parameter template. For more information, see Use a parameter template to manage parameters.
  1. Log on to the ApsaraDB for RDS console.
  2. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where the target RDS instance resides.
    Select a region
  3. Find the target instance and click the instance ID.
  4. In the left-side navigation pane, click Parameters.
  5. Perform the following operations based on your business scenario:
    • Apply a parameter template to the RDS instance.
      Note If an instance restart is required, we recommend that you apply the parameter template during off-peak hours and make sure that your application is configured to automatically reconnect to the RDS instance.
      1. On the Editable Parameters tab, click Apply Template.
      2. In the Apply Template dialog box, select the parameter template and click OK.
        Note
        • You can view the number of parameters in the parameter template and check whether you need to restart the RDS instance. For more information about the parameter reconfiguration history, click View Parameter Change.
        • If you cannot find the parameter template, check whether the parameter template belongs to the same region as the RDS instance. If they belong to different regions, you can copy the parameter template to the region to which the RDS instance belongs. For more information, see Use a parameter template to manage parameters.
    • Export the parameter settings of the RDS instance as a parameter template in the current region.
      1. On the Editable Parameters tab, click Export as Template.
      2. Configure the following parameters.
        Parameter Description
        Template Name The name of the parameter template. The name must be 8 to 64 characters in length. It can contain letters, digits, periods (.), and underscores (_). It must start with a letter.
        Description The description that helps identify the parameter template. The description can be up to 200 characters in length.
      3. Click OK.
    • Export the parameter settings of the RDS instance to your computer.

      On the Editable Parameters tab, click Export Parameters. The parameter settings of the RDS instance are exported as a TXT file to your computer.

      1. Reconfigure the parameters in the TXT file, click Import Parameters, and in the Import Parameters dialog box paste the new parameter values you have copied from the TXT file.
      2. Click OK.
      3. In the upper-right corner of the page, click Apply Changes.
        Note
        • If the new parameter values can take effect only after an instance restart, the system prompts you to restart the RDS instance. We recommend that you restart the RDS instance during off-peak hours and make sure that your application is configured to automatically reconnect to the RDS instance.
        • Before the new parameter values are applied, you can click Cancel Changes to cancel them.
    • Reconfigure a single parameter of the RDS instance.
      1. On the Editable Parameters tab, find the parameter that you want to reconfigure, and click the icon in the Actual Value column.
      2. Enter a new value based on the prompted value range.
      3. Click Confirm.
      4. In the upper-right corner of the page, click Apply Changes.
        Note
        • If the new parameter value can take effect only after an instance restart, the system prompts you to restart the RDS instance. We recommend that you restart the RDS instance during off-peak hours and make sure that your application is configured to automatically reconnect to the RDS instance.
        • Before the new parameter value is applied, you can click Cancel Changes to cancel it.

View the parameter reconfiguration history

  1. Log on to the ApsaraDB for RDS console.
  2. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where the target RDS instance resides.
    Select a region
  3. Find the target instance and click the instance ID.
  4. In the left-side navigation pane, click Parameters.
  5. Click the Edit History tab.
  6. Select a time range and click Search.

FAQ

  • After I reconfigure the parameters of my RDS instance, will the new parameter values take effect immediately? And do I need to restart my RDS instance?

    Some parameters do not require an instance restart after they are reconfigured. The new values of these parameters take effect in about 5 minutes. Some parameters require an instance restart after they are reconfigured. For more information, refer to the Force Restart column on the Editable Parameters tab in the ApsaraDB for RDS console.

  • After I reconfigure the parameters of my RDS instance, why cannot the new parameter values take effect?

    After you reconfigure the parameters of your RDS instance, you must click Apply Changes in the upper-right corner of the Editable Parameters tab in the ApsaraDB for RDS console. This makes the new parameter values take effect.

Related operations

Operation Description
Modify instance parameters Reconfigures the parameters of an ApsaraDB for RDS instance.
Query parameter template Queries the parameter templates available to use for an ApsaraDB for RDS instance.
Query parameter configurations Queries the parameter settings of an ApsaraDB for RDS instance.