You can modify instance parameters. After submitting a request, the RDS assigns a task and the new parameter is applied to the instance. If any submitted parameter requires that the database be restarted, the RDS restarts the database. Instances must meet the following conditions, or the call may fail:

  • The current instance status is Running.

  • The current instance lock mode is Normal.

There are three types of parameter values:

  • [1-65535]: indicates a numerical range. Regular identification is used to extract the minimum and maximum values. Then the input parameter is verified based on the minimum and maximum values. In addition, the parameter must be a multiple of a divisible factor.

  • [utf8|gbk|latin1]: indicates a set value determination rule. Regular identification is used to extract the fixed value. Then the parameter is verified based on these fixed values.

  • Others: a regular expression must apply.

Before the task is assigned, the RDS checks the parameter as follows:

  • Whether the parameter exist.

  • Whether the parameter can be modified.

  • Whether the parameter is valid.

If the parameter is invalid, the RDS returns Error Code 400 and the information about the invalid parameter. For example:

"Message":"Specified parameter is not valid.[auto_increment_increment:a,character_set_client:41]"}

Request parameters

Name Type Required? Description
Action String Yes required parameter. Value: ModifyParameter.
DBInstanceId String Yes Instance ID.
Parameters String Yes JSON string for the parameter and its value. The parameter value must be string-type. {“auto_increment_increment”:”1”, “character_set_client”:”utf8”}.
Forcerestart String No true: force restart (true must be input when a parameter among parameters to be modified needs to be restarted; otherwise, the modification is invalid). False: force restart disabled. The force restart is disabled by default.

Return parameters

Name Type Description
<Public Return Parameters> For more information, see Public parameters.

Request example
&<Public Request Parameters>

Response example

XML format:


JSON format: