This topic describes how to view and reconfigure the parameters of an ApsaraDB RDS for MySQL instance by using the ApsaraDB for RDS console or the API. You can also view the parameter reconfiguration history in the ApsaraDB for RDS console.
Precautions
- To ensure instance stability, the ApsaraDB for RDS console allows you to reconfigure only some parameters. If you cannot find the parameter that you want to reconfigure, submit a ticket.
- When you reconfigure parameters, you can refer to the Value Range column on the Editable Parameters tab in the ApsaraDB for RDS console.
- The new values of some parameters can take effect only after an instance restart. For more information, refer to the Force Restart column on the Editable Parameters tab in the ApsaraDB for RDS console. We recommend that you reconfigure parameters during off-peak hours and make sure that your application is configured to automatically reconnect to your RDS instance.
Reconfigure parameters
View the parameter reconfiguration history
FAQ
- After I reconfigure the parameters of my RDS instance, will the new parameter values
take effect immediately? And do I need to restart my RDS instance?
Some parameters do not require an instance restart after they are reconfigured. The new values of these parameters take effect in about 5 minutes. Some parameters require an instance restart after they are reconfigured. For more information, refer to the Force Restart column on the Editable Parameters tab in the ApsaraDB for RDS console.
- After I reconfigure the parameters of my RDS instance, why cannot the new parameter
values take effect?
After you reconfigure the parameters of your RDS instance, you must click Apply Changes in the upper-right corner of the Editable Parameters tab in the ApsaraDB for RDS console. This makes the new parameter values take effect.
Related operations
Operation | Description |
---|---|
Modify instance parameters | Reconfigures the parameters of an ApsaraDB for RDS instance. |
Query parameter template | Queries the parameter templates available to use for an ApsaraDB for RDS instance. |
Query parameter configurations | Queries the parameter settings of an ApsaraDB for RDS instance. |