This topic describes how to use the ApsaraDB for RDS console or APIs to view and modify parameters of an RDS for MariaDB instance.

Precautions

  • To ensure instance stability, the console allows you to modify only part of the parameters. If you want to modify more parameters, ,submit a ticket.
  • When you modify parameters on the Editable parameters tab, refer to the Value Range column.
  • After you modify certain parameters, you must restart the instance for the changes to take effect. For more information, refer to the Force Restart column on the Editable parameters tab. We recommend that you modify the parameters of an instance during off-peak hours and make sure that your application supports automatic reconnection.

Modify the parameters

  1. Log on to the ApsaraDB for RDS console.
  2. In the top navigation bar, select the region where the target RDS instance resides.Select a region
  3. Find the target RDS instance and click its ID.
  4. In the left-side navigation pane, select Parameters.
  5. On the Editable Parameters tab, modify the target parameters. You can modify one or more parameters at a time.
    • Modify a single parameter.
      1. Click the icon following the target parameter.
      2. Enter a new value and click Confirm.
      3. In the upper-right corner of the page, click Apply Changes.
      4. In the Edit Parameters dialog box, click Confirm.
    • Modify multiple parameters at a time.
      1. Click Export Parameters.
      2. Open the parameter file and modify the parameters.
      3. After you modify the parameters, click Import Parameters.
      4. In the Import Parameters dialog box, paste the parameters and new values and click OK.
      5. Confirm the parameter values in the list and click Apply Changes.

Query the parameter modification history

  1. Log on to the ApsaraDB for RDS console.
  2. In the top navigation bar, select the region where the target RDS instance resides.Select a region
  3. Find the target RDS instance and click its ID.
  4. In the left-side navigation pane, click Parameters.
  5. Click the Edit History tab.
  6. Select a time range and click Search.

Parameter description

For more information, see MariaDB parameters.

Related operations

Operation Description
ModifyParameter Modifies the parameters of an RDS instance.
DescribeParameterTemplates Queries the parameter templates available to an RDS instance.
DescribeParameters Queries the parameter settings of an RDS instance.