You can view and reconfigure some parameters for your RDS instance through the RDS console or APIs. Additionally, you can view the parameter reconfiguration history on the RDS console.

Note For instances of SQL Server 2012 or later, you can set their parameters only by running SQL commands. For more information, see Use SQL commands to set parameters.

Precautions

  • The new parameter values must be within the allowed value ranges shown on the Modifiable Parameters tab page of the RDS console.
  • Your RDS instance must be restarted after some of its parameters are reconfigured. On the Modifiable Parameters tab page, you can check the value in the Force Restart column for a parameter to determine whether you must restart your RDS instance after you reconfigure the parameter. Restarting an RDS instance interrupts the connection to the instance. Therefore, before restarting your RDS instance, you must guarantee appropriate business arrangements.

Reconfigure parameters

  1. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.
    地域截图
  3. Find the target RDS instance and click its ID to open the Basic Information page.
  4. In the left-side navigation pane, click Parameters.
  5. Click the Modifiable Parameters tab.
  6. Reconfigure parameters.
    • To reconfigure a parameter:
      1. Click following the parameter.
      2. Enter the target value and click Confirm.
      3. Click Apply Changes.
      4. In the displayed dialog box, click Confirm.


    • To reconfigure multiple parameters:
      1. Click Export Parameters to export the parameters as a .txt file to your computer.
      2. Open the file and reconfigure parameters.
      3. Click Import Parameters.
      4. In the displayed Import Parameters dialog box, copy and paste the parameters to be reconfigured and their values, then click OK
      5. Confirm the parameter reconfiguration results in the parameter list and click Apply Changes.


View the parameter reconfiguration history

  1. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.
    地域截图
  3. Find the target RDS instance and click its ID to open the Basic Information page.
  4. In the left-side navigation pane, click Parameters.
  5. Click the Modification History tab.
  6. Select a time range and click Search.

APIs

Parameters

If you are new to ApsaraDB RDS, begin learning more with the following resources:

Best practice

For more information, see Parameter optimization for MySQL instances.