Modify parameters

You can modify the values and effective scopes of cluster or tenant parameters as needed.

Procedure

1. Log on to the OceanBase Cloud Platform (OCP) console.

2. In the left-side navigation pane, click Clusters to go to the Clusters page.

3. In the Clusters list, find the target cluster and click its name.

4. In the left-side navigation pane of the page that appears, click Parameter Management.

5. Optional. In the search box of the Parameters page, enter a parameter name to perform a fuzzy search.

   

6. Find the parameter to be modified and click Change Value in the Actions column.

7. In the dialog box that appears, modify the parameter value, effective scope, and effective objects. Then, click OK. The following figure shows how to modify a parameter whose effective scope is Cluster.

   

   The effective scope varies with parameters. Therefore, you must select the effective scope when you modify the parameter value.

   • When the effective scope is Cluster or a custom scope, the default effective scope is Cluster. If you need to narrow the effective scope down to Zone or OBServer, select Zone or OBServer from the Effective Scope drop-down list. Select effective objects. The modified value takes effect on the specified effective objects.

   • When the effective scope is Tenant, you can select specific tenants from the Effective Object drop-down list, or select All to select all tenants. The modified value takes effect on the specified effective objects.

   If you want to specify different parameter values in different scopes, for example, you want the value of backup_concurrency to be 10 in Zone 1, 12 in Zone 2, and 20 on Server 1, you can click Add Value to add three record rows, and then select the corresponding effective scope in each row.

   Note

   • If multiple rows of values are displayed after you click Add Value, modify the parameter values from the top down. For each successful modification operation, a record is generated on the Change History tab.
   • You must specify a unit for capacity-related parameters. Otherwise, the parameter configuration will fail.