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 document.

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 database parameters, refer to the following official documents:

Considerations

  • Configure parameters only within the allowed value ranges shown on the Parameter Settings page.
  • The instance must be restarted after its parameters are changed. See the Force Restart parameter on the Parameters page to confirm if a restart is required. Before restarting an instance, to avoid interruptions, you must guarantee appropriate business arrangements. A restart will cause instance disconnection. Restart the instance with caution.

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. Click the Modifiable Parameters tab.
  6. Select the parameter modification method.
    • To modify a parameter

      1. Click following the parameter to modify.
      2. In the dialog box, 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 modify relevant parameters in batches.
      3. Click Import Parameters, marked as 2 in the following figure.
      4. In the Import Parameters window, paste the parameters to be modified and their 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. Click the Modification History tab.
  6. Select the time range that you want to query, and click Query.

API references

Best practice

Parameter optimization for MySQL instances