Set parameters

Last Updated: May 03, 2017

RDS allows you to define some instance parameters. For details about the parameters that can be configured, see Parameter Settings on the RDS Console .

Considerations

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

  • The instance must be restarted after modifying certain parameters. Refer to the parameter settings page to confirm if a restart is required. Before restarting, to avoid any interruption of production, ensure the appropriate business arrangements.

Background information

RDS is compatible with the native database service, with similar parameter setting methods. You can configure parameters through the RDS console by referring to this example, or through APIs to run related commands.

For a description of the database parameters, click the following link to review the official documents of different database versions.

Operation procedure

  1. Log on to the RDS Console and select the target instance.

  2. Select Parameter Settings in the instance menu.

  3. Select the parameter modification method.

    • To modify a parameter

      1. Click the Modify Icon following the parameter to modify. In the pop-up window, enter the target value and click OK, as indicated by 1 in the image below.

      2. Click Submit modify to confirm the setting, as indicated by 2 in the image below.

        Modifying One Parameter

    • To batch modify parameters

      1. Click Export Parameters to export the parameter file (.txt) to your local device, as indicated by 1 in the image below.

      2. Open the parameter file and batch modify the relevant parameters.

      3. Click Import Parameters, as indicated by 2 in the image below.

      4. In the Import Parameters window, paste the parameters to modify and the parameter values and click OK, as indicated by 3 and 4 in the image below.

      5. Confirm the parameter modification results in the parameter list and click Submit modify, as indicated by 5 in the image below.

        Batch Modifying Parameters

View the modification history

You can review the modification records on the Modification History tab page.

Thank you! We've received your feedback.