All Products
Search
Document Center

ApsaraDB RDS:Modify parameters

Last Updated:Feb 07, 2024

ApsaraDB RDS for MariaDB allows you to view and modify the parameters of an ApsaraDB RDS for MariaDB instance in the ApsaraDB RDS console or by calling API operations. You can also view the parameter modification history.

Usage notes

  • The modification of some parameters triggers a restart of your RDS instance. After you modify the parameters and click Apply Changes, your RDS instance immediately restarts. To check whether the modification of a parameter triggers a restart, you can log on to the ApsaraDB RDS console, go to the Editable Parameters tab, and then view the value in the Force Restart column for the parameter. If the value is Yes, the modification of the parameter triggers a restart. If the value is No, the modification of the parameter does not trigger a restart. We recommend that you modify parameters during off-peak hours and make sure that your application is configured to automatically reconnect to your RDS instance.

  • To ensure instance stability, you can modify specific parameters in the ApsaraDB RDS console.

  • When you modify the parameters of your RDS instance, you can view the valid values of a parameter in the Value Range column of the parameter on the Editable Parameters tab of the Parameters page in the ApsaraDB RDS console.

Modify parameters

  1. Log on to the ApsaraDB RDS console.

  2. In the top navigation bar, select the region in which your RDS instance resides.

  3. Find the RDS instance and click the instance ID.

  4. In the left-side navigation pane, click Parameters.

  5. On the Editable Parameters tab, modify the parameters of the RDS instance based on your business requirements.

    • Modify a single parameter of the RDS instance.

      1. Find the parameter and click the icon.

      2. Enter a new value and click OK.

      3. In the upper part of the page, click Apply Changes.

      4. In the dialog box that appears, click OK.

    • Modify multiple parameters at a time.

      1. Click Export Parameters to download the parameter settings of your RDS instance as a file to your computer.

      2. Open the file and modify the parameters.

      3. Click Import Parameters.

      4. In the Import Parameters dialog box, paste the parameter settings that you have copied from the file. Then, click OK.

      5. Confirm the values of the modified parameters and click Apply Changes. In the dialogue box that appears, click OK.

View the parameter configuration history

  1. Log on to the ApsaraDB RDS console.

  2. In the top navigation bar, select the region in which the RDS instance resides.

  3. Find the RDS instance and click the instance ID.

  4. In the left-side navigation pane, click Parameters.

  5. Click the Edit History tab.

  6. Select a time range and click OK.

Parameter description

For more information, see MariaDB parameters.

FAQ

  • Does the modification of instance parameters take effect immediately? Do I need to restart my RDS instance?

    After you modify the parameters of your RDS instance, the new values of some parameters take effect in approximately 5 minutes even if you do not restart your RDS instance. However, the new values of some parameters take effect only after you restart your RDS instance. You can check the values in the Force Restart column on the Editable Parameters tab of the Parameters page in the ApsaraDB RDS console to view the parameters that require instance restart.

  • After I modify the parameters of my RDS instance, why do the new values of the parameters not take effect?

    Make sure that you click Apply Changes after you modify the parameters.

Related operations

Operation

Description

ModifyParameter

Modifies the parameters of an instance.

DescribeParameterTemplates

Queries the parameter templates that are available for an instance.

DescribeParameters

Queries the parameter settings of an instance.