Modify instance parameters

Usage notes

• Some parameter changes require an instance restart to take effect. The instance may restart immediately after you click Apply Changes. For details, see the Force Restart column on the Editable Parameters page in the console. We recommend applying these changes during off-peak hours and ensuring your application has an automatic reconnection mechanism.

• To ensure instance stability, only a subset of parameters can be modified in the console.

• When modifying a parameter value, refer to the Value Range column on the Editable Parameters page.

Modify parameter values

1. Log on to the ApsaraDB RDS console.

2. In the upper-left corner of the page, select the region where the instance is located.

3. Find the target instance and click its instance ID.

4. In the navigation pane on the left, click Parameters.

5. On the Editable Parameters tab, find the desired parameter(s):

   • Modify a single parameter

     1. Click the icon next to the desired parameter.

     2. Enter a new value and click OK.

     3. In the upper-right corner of the page, click Apply Changes.

     4. In the dialog box, click OK.

   • Modify parameters in bulk

     1. Click Export Parameters to export the parameter file to your local computer.

     2. Open the parameter file and modify the parameter values.

     3. Click Import Parameters.

     4. In the Import Parameters dialog box, paste the parameters and their new values, and then click OK.

     5. Confirm the parameter changes in the list, click Apply Changes, and then click OK in the dialog box.

View parameter modification history

1. Log on to the ApsaraDB RDS console.

2. In the upper-left corner of the page, select the region where the instance is located.

3. Find the target instance and click its instance ID.

4. In the navigation pane on the left, click Parameters.

5. Click the Edit History tab.

6. Select a time range and click OK.

Parameters

For parameter descriptions, see the official MariaDB server system variables documentation.

FAQ

• Do parameter changes take effect immediately? Is a restart required?

  Some parameter changes take effect within five minutes without a restart, while others take effect only after the instance is restarted. For details, see the Force Restart column on the Editable Parameters page in the console.

• Why are my parameter changes not applied?

  After modifying a parameter, you must click Apply Changes to submit the change.

Related APIs