Modify the major compaction settings of a cluster

You can configure custom strategies for minor compactions and daily major compactions of a cluster as needed. A cluster-level strategy takes effect on all tenants in the cluster. For more information about how to configure different minor and major compaction strategies for each tenant in a cluster, see Modify major compaction settings of a tenant.

Prerequisites

Make sure that you have the following permissions:

• Resource Permissions : Cluster Maintenance permission
• Menu Permissions : Permission on the Compaction Management menu of Clusters

Procedure

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

   The Clusters page automatically appears.

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

3. In the left-side navigation pane of the page that appears, click Compaction Management .

4. Click the Configuration for Major Compaction tab.

   Note

   Tenants with different major compaction strategies in the cluster are displayed in groups based on their strategies.

   

5. Configure the major compaction strategies.

   1. In the upper-right corner of the Major Compaction Strategy section, click Modify .

   2. Hover the pointer over the icon of a parameter and configure the major compaction strategy as prompted.

   3. After you configure the strategy, click Save .

   Note

   If the major compaction speed is slow, you can appropriately increase the value of Merge task weight. However, this decreases the weights of other running tasks in OceanBase Database, such as backup and recovery tasks. Therefore, when multiple tasks are running in OceanBase Database at the same time, you need to determine whether to modify the weight of the major compaction task based on task priorities.

6. Configure the minor compaction strategy.

   1. In the upper-right corner of the Minor Compaction Strategy section, click Modify .

   2. Hover the pointer over the icon of a parameter and configure the minor compaction strategy as prompted.

   3. After you configure the strategy, click Save .

   Note

   The modified cluster-level strategy overwrites inconsistent strategies of all tenants in the cluster. Proceed with caution.