RDS allows you to define some instance parameters. For details about the parameters that can be configured, see Parameter Settings on the RDS Console .
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.
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.
Log on to the
RDS Consoleand select the target instance.
Select Parameter Settings in the instance menu.
Select the parameter modification method.
To modify a parameter
Click the 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.
Click Submit modify to confirm the setting, as indicated by 2 in the image below.
To batch modify parameters
Click Export Parameters to export the parameter file (.txt) to your local device, as indicated by 1 in the image below.
Open the parameter file and batch modify the relevant parameters.
Click Import Parameters, as indicated by 2 in the image below.
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.
Confirm the parameter modification results in the parameter list and click Submit modify, as indicated by 5 in the image below.
You can review the modification records on the Modification History tab page.