Note
This view is available starting with V4.2.0.
Purpose
This view displays the history of load balancing tasks executed in the tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TASK_ID | bigint(20) | NO | The ID of the load balancing task. |
| CREATE_TIME | timestamp(6) | NO | The start time of the task. |
| FINISH_TIME | timestamp(6) | NO | The end time of the task, including the time when the task is successfully completed or canceled. |
| TASK_TYPE | varchar(64) | NO | The task type. Valid values: LS_SPLIT, LS_ALTER, LS_MERGE, and LS_TRANSFER.
|
| SRC_LS | bigint(20) | NO | The source log stream (the log data stream generated from 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 that have been balanced. |
| PART_COUNT | bigint(20) | YES | The number of partitions in the partition list. |
| FINISHED_PART_COUNT | bigint(20) | YES | The number of partitions that have been balanced. |
| LS_GROUP_ID | bigint(20) | NO | The ID of the log stream group. |
| STATUS | varchar(64) | NO | The task status. Valid values: INIT, CREATE_LS, ALTER_LS, SET_LS_MERGING, DROP_LS, COMPLETED, and CANCELED.
|
| PARENT_LIST | varchar(1024) | YES | The list of parent tasks. |
| CHILD_LIST | varchar(1024) | YES | The list of child tasks. |
| 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 comment. |
| BALANCE_STRATEGY | varchar(64) | YES | The balance strategy corresponding to the balance task. Valid values: LS balance by migrate, LS balance by alter, LS balance by expand, LS balance by shrink, and partition balance.
NoteFor V4.3.x, this column is available starting with V4.3.2. For V4.2.x, this column is available starting with V4.2.4. |
Sample query
Query the history of load balancing tasks executed in the tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BALANCE_TASK_HISTORY\G
The query result is as follows:
*************************** 1. row ***************************
TASK_ID: 318280
CREATE_TIME: 2025-05-09 14:29:05.504906
FINISH_TIME: 2025-05-09 14:29:13.589729
TASK_TYPE: LS_SPLIT
SRC_LS: 1001
DEST_LS: 1002
PART_LIST: NULL
FINISHED_PART_LIST: 500002:500008,500002:500011,500002:500014
PART_COUNT: 0
FINISHED_PART_COUNT: 3
LS_GROUP_ID: 1001
STATUS: COMPLETED
PARENT_LIST: NULL
CHILD_LIST: NULL
CURRENT_TRANSFER_TASK_ID: -1
JOB_ID: 318278
COMMENT: NULL
BALANCE_STRATEGY: LS balance by expand
*************************** 2. row ***************************
TASK_ID: 318454
CREATE_TIME: 2025-05-09 14:29:45.565764
FINISH_TIME: 2025-05-09 14:29:53.633471
TASK_TYPE: LS_MERGE
SRC_LS: 1002
DEST_LS: 1001
PART_LIST: NULL
FINISHED_PART_LIST: 500002:500008,500002:500011,500002:500014
PART_COUNT: 0
FINISHED_PART_COUNT: 3
LS_GROUP_ID: 1001
STATUS: COMPLETED
PARENT_LIST: NULL
CHILD_LIST: NULL
CURRENT_TRANSFER_TASK_ID: -1
JOB_ID: 318453
COMMENT: NULL
BALANCE_STRATEGY: LS balance by shrink
*************************** 3. row ***************************
TASK_ID: 318539
CREATE_TIME: 2025-05-09 14:30:05.606117
FINISH_TIME: 2025-05-09 14:30:14.069126
TASK_TYPE: LS_SPLIT
SRC_LS: 1001
DEST_LS: 1003
PART_LIST: NULL
FINISHED_PART_LIST: 500002:500008,500002:500011,500002:500014
PART_COUNT: 0
FINISHED_PART_COUNT: 3
LS_GROUP_ID: 1001
STATUS: COMPLETED
PARENT_LIST: NULL
CHILD_LIST: NULL
CURRENT_TRANSFER_TASK_ID: -1
JOB_ID: 318537
COMMENT: NULL
BALANCE_STRATEGY: LS balance by expand
3 rows in set
References
Query the load balancing tasks (Task) at the log stream level in the current tenant: DBA_OB_BALANCE_TASKS
Query the load balancing jobs (Job) at the log stream level in the current tenant:
Query the load balancing tasks (Task) at the tablet level in the current tenant:
Query the transfer partition tasks (Task) in the current tenant:
For more information about data load balancing, see Data load balancing.