Views
| View | Description |
|---|---|
| DBA_OB_TABLE_LOCATIONS/CDB_OB_TABLE_LOCATIONS | Displays the distribution of partition replicas, including the partition details. This is one of the most commonly used views. |
| DBA_OB_LS_LOCATIONS/CDB_OB_LS_LOCATIONS | Displays the distribution of log stream (LS) replicas. |
| DBA_OB_BALANCE_JOBS/CDB_OB_BALANCE_JOBS | Displays the ongoing load balancing jobs, such as scaling jobs and partition balancing jobs. |
| DBA_OB_BALANCE_JOB_HISTORY/CDB_OB_BALANCE_JOB_HISTORY | Displays the history of load balancing jobs. |
| DBA_OB_BALANCE_TASKS/CDB_OB_BALANCE_TASKS | Displays the ongoing LS balancing tasks, such as LS splitting tasks and LS merging tasks. |
| DBA_OB_BALANCE_TASK_HISTORY/CDB_OB_BALANCE_TASK_HISTORY | Displays the history of LS balancing tasks. |
| DBA_OB_TRANSFER_TASKS/CDB_OB_TRANSFER_TASKS | Displays the ongoing transfer tasks. |
| DBA_OB_TRANSFER_TASK_HISTORY/CDB_OB_TRANSFER_TASK_HISTORY | Displays the history of transfer tasks. |
| GV$OB_UNITS | Displays the expected distribution and persisted resources of units. |
| GV$OB_SERVERS | Displays the actual distribution and resources of units on each server. |
Parameters
| Parameter | Level | Default value | Description | Affected balancing strategy |
|---|---|---|---|---|
| enable_rebalance | Tenant level | true | Specifies whether to enable load balancing. In the sys tenant, this parameter controls unit balancing. In a user tenant, this parameter controls LS balancing and partition balancing. | Intra-tenant balancing and inter-tenant balancing |
| enable_transfer | Tenant level | true | Specifies whether to enable transfer. If this parameter is set to false, all transfer actions are prohibited. If enable_rebalance is set to true and enable_transfer is set to false, a special strategy is used to achieve balancing, with the LS quantity unchanged. |
Intra-tenant balancing |
| balancer_idle_time | Tenant level | 10s | The interval at which the load balancing background thread performs a scan. | Intra-tenant balancing |
| enable_ls_leader_balance | Tenant level | true | Specifies whether to enable log stream leader balancing. When enable_rebalance is enabled, you can disable enable_ls_leader_balance to disable automatic log stream leader balancing. |
LS balancing |
| partition_balance_schedule_interval | Tenant level | 0s | The interval for scheduling partition balancing, which starts from the point in time when the tenant is created or the cluster is restarted.
NoticeFor V4.4.x, the default value of this parameter was changed to 0s starting from V4.4.1. For V4.4.1 and later versions, this parameter is not recommended for controlling partition balancing. You can call the |
Partition balancing |
| balancer_tolerance_percentage | Cluster level | 10 | The tolerance in percentage for partition disk balancing at the LS level. When balanced, the disk usage difference between each two LSs does not exceed this percentage. | Partition disk balancing |
| server_balance_cpu_mem_tolerance_percent | Cluster level | 5 | The threshold in percentage for triggering unit balancing. If the difference between the unit load on any node and the average unit load exceeds this threshold, unit balancing is triggered to migrate units. | Unit balancing |
| server_balance_critical_disk_waterlevel | Cluster level | 80 | The disk usage threshold in percentage. Unit balancing is triggered when the disk usage exceeds this threshold. | Unit balancing |