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

Precautions

  • For instance stability purposes, you are allowed to modify only some parameters in the ApsaraDB for RDS console. If you want to modify more parameters, submit a ticket.
  • When you modify parameters on the Editable Parameters tab, refer to the Value Range column that corresponds to each parameter.
  • 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 modify these parameters during off-peak hours and make sure that your application is configured to automatically reconnect to your RDS instance.

Modify parameters

  1. Log on to the ApsaraDB for RDS console.
  2. In the top navigation bar, select the region where the target RDS instance resides.Select a region
  3. Find the target RDS instance and click its ID.
  4. In the left-side navigation pane, click Parameters.
  5. On the Editable Parameters tab, reconfigure one or more parameters. You can modify one or more parameters at a time.
    • To modify a single parameter, follow these steps:
      1. Find the parameter and click the icon in the Actual Value column.
      2. In the dialog box that appears, enter a new value within the value range and click Confirm.
      3. In the upper-right corner of the page, click Apply Changes.
      4. In the dialog box that appears, click OK.
    • To modify more than one parameter at a time, follow these steps:
      1. In the upper-right corner, click Export Parameters to download the parameters and their values as a file to your computer.
      2. Open the file and modify parameters.
      3. In the upper-right corner, click Import Parameters.
      4. In the Import Parameters dialog box, paste the parameters and their new values copied from the file and click OK.
      5. Verify the parameter values and click Apply Changes.

View the parameter modification history

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

Parameter description

For more information, see PPAS parameters in official PPAS documentation.

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 an ApsaraDB for RDS instance.
Query parameter configurations Queries the parameter settings of an ApsaraDB for RDS instance.