RDS allows you to define some instance parameters. For more information about the parameters that can be configured, see Parameter Settings on the RDS console. This document describes how to modify parameters and view the modification history on the RDS console. To perform these operations using APIs, see API references at the end of this article.

Note
  • PostgreSQL instances do not support user-defined parameters.

  • To set parameters for instances of SQL Server 2012 and later versions, use SQL commands. For more information, see Use SQL commands to set parameters.

Background information

For descriptions about the database parameters, see the following official documents:

Considerations

  • Configure parameters only within the permissible value ranges shown on the parameter settings page.

  • The instance must be restarted after modifying certain parameters. See the Force Restart parameter on the Parameters page to confirm if a restart is required. Before restarting, to avoid any interruption of production, you must guarantee the appropriate business arrangements. A restart will disconnect the instance. Exercise caution to restart the instances.

Procedure

  1. Log on to the RDS console.
  2. Select the region where the target instance is located.
  3. Click the ID of the instance to visit the Basic Information page.
  4. Select Parameters on the left-side navigation pane.
  5. Select the Modifiable Parameters tab.
  6. Select the parameter modification method.
    • To modify a parameter

      1. Click the icon following the parameter to modify.
      2. In the dialog box window, enter the target value in the field marked as 1 and click OK.
      3. Click Submit modify to confirm the setting, marked as 2 in the following figure.


    • To modify multiple parameters:

      1. Click Export Parameters to export the parameter file (.txt) to your local device, marked as 1 in the following figure.
      2. Open the parameter file and batch modify the relevant parameters.
      3. Click Import Parameters, marked as 2 in the following figure.
      4. In the Import Parameters window, paste the parameters to modify and the parameter values and click OK, marked as 3 and 4 in the following figure.
      5. Confirm the parameter modification results in the parameter list and click Submit modify, marked as 5 in the following figure.

View the modification history

  1. Log on to the RDS console.
  2. Select the region where the target instance is located.
  3. Click the ID of the instance to visit the Basic Information page.
  4. Select Parameters in the left-side navigation pane.
  5. Select the Modification History tab.
  6. Select the time range that you want to query, and click Query.

API references

Best practices

Parameter optimization for MySQL instances