Note
This view was introduced in OceanBase Database V4.2.0.
Purpose
The oceanbase.DBA_OB_BALANCE_TASKS view displays the ongoing load balancing tasks in the current tenant. Each tenant can have multiple ongoing load balancing tasks, which belong to the same load balancing job.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TASK_ID | bigint(20) | NO | The ID of the load balancing task. |
| CREATE_TIME | timestamp(6) | YES | The time when the task was created. |
| MODIFY_TIME | timestamp(6) | YES | The time when the task was last modified. |
| TASK_TYPE | varchar(64) | NO | The type of the task. Valid values:
|
| SRC_LS | bigint(20) | NO | The source log stream, which is generated at the data source. |
| DEST_LS | bigint(20) | NO | The destination log stream. |
| PART_LIST | longtext | YES | The list of partitions, including user table partitions and global index partitions. |
| FINISHED_PART_LIST | longtext | YES | The list of partitions for which load balancing has been completed. |
| PART_COUNT | bigint(20) | YES | The number of partitions in the partition list. |
| FINISHED_PART_COUNT | bigint(20) | YES | The number of partitions for which load balancing has been completed. |
| LS_GROUP_ID | bigint(20) | NO | The ID of the log stream group. |
| STATUS | varchar(64) | NO | The status of the task. Valid values:
|
| PARENT_LIST | varchar(1024) | YES | The list of parent tasks. |
| CHILD_LIST | varchar(1024) | YES | The list of subtasks. |
| CURRENT_TRANSFER_TASK_ID | bigint(20) | NO | The ID of the transfer task triggered by the current load balancing task. |
| JOB_ID | bigint(20) | NO | The ID of the job to which the current task belongs. |
| COMMENT | longtext | YES | The comments. |
| BALANCE_STRATEGY | varchar(64) | YES | The load balancing strategy for the load balancing task.
NoteThis column was introduced in OceanBase Database V4.2.4. |
Sample query
Query the ongoing load balancing tasks in the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BALANCE_TASKS\G
Query result:
*************************** 1. row ***************************
TASK_ID: 318280
CREATE_TIME: 2025-05-09 14:29:05.504906
MODIFY_TIME: 2025-05-09 14:29:07.535966
TASK_TYPE: LS_SPLIT
SRC_LS: 1001
DEST_LS: 1002
PART_LIST: 500002:500008,500002:500011,500002:500014
FINISHED_PART_LIST: NULL
PART_COUNT: 3
FINISHED_PART_COUNT: 0
LS_GROUP_ID: 1001
STATUS: TRANSFER
PARENT_LIST: NULL
CHILD_LIST: NULL
CURRENT_TRANSFER_TASK_ID: -1
JOB_ID: 318278
COMMENT:
BALANCE_STRATEGY: LS balance by expand
1 row in set
References
Query the history of load balancing tasks at the log stream level in the current tenant. DBA_OB_BALANCE_TASK_HISTORY
Query load balancing jobs at the log stream level in the current tenant.
Query load balancing tasks at the tablet level in the current tenant.
Query transfer partition tasks in the current tenant.
For more information about data load balancing, see Data load balancing.