This topic describes how to change the parameter values of clusters in the PolarDB console.

Background information

You can change the parameter values of clusters in the PolarDB console. For more information about the parameters, see Server System Variables.

Procedure

  1. Log on PolarDB console.
  2. On the top of the page, select the region where the target cluster is located.
  3. Find the target cluster and click the cluster ID to go to the Overview page.
  4. In the left-side navigation pane, choose Settings and Management > Parameters.
  5. Find the parameter for which you want to change the value, and click the Icon icon in the Current Value column. In the dialog box that appears, enter the new value and click OK.
    Apply the changes
    Note
    • You must enter the parameter values that are included in the right-side Value Range column. Otherwise, an error message appears when you Apply Changes.
    • You can move your pointer over the Parameter icon icon of a parameter to view the parameter details.
  6. In the left-right corner, click Apply Changes. In the Save Changes panel, click OK.
    Save Changes panel
    Note
    • After you click Apply Changes for a parameter for which the value of Force Restart is Yes, you must restart all the nodes in the cluster to apply the changes. We recommend that you make appropriate service arrangements before you restart the nodes. Use caution if you need to restart the nodes.
    • If your cluster version is PolarDB for MySQL 8.0, you can specify the innodb_fast_startup parameter as ON to accelerate the restart process. For more information about how to change parameter values, see Specify cluster parameters.

Related API operations

API Description
DescribeDBClusterParameters Queries the parameters of a specified PolarDB cluster.
ModifyDBClusterParameters Changes the parameter values of a specified PolarDB cluster.