Note
This view is available starting with V4.2.0.
Purpose
This view displays the load balancing jobs that are currently being executed for the tenant. Each tenant can have only one load balancing job running at a time. Each load balancing job generates multiple load balancing tasks (TASK) to perform the specific load balancing operations.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The ID of the load balancing job. |
| CREATE_TIME | timestamp(6) | YES | The time when the job was created. |
| MODIFY_TIME | timestamp(6) | YES | The time when the information was last updated. |
| BALANCE_STRATEGY | varchar(64) | NO | The name of the balancing strategy.
|
| JOB_TYPE | varchar(64) | NO | The type of the task.
|
| TARGET_UNIT_NUM | bigint(20) | NO | The number of units in each zone that are to be changed.
Note
|
| TARGET_PRIMARY_ZONE_NUM | bigint(20) | NO | The number of primary zones that are to be changed. |
| STATUS | varchar(64) | NO | The status of the task.
|
| COMMENT | longtext | YES | The comment. |
| MAX_END_TIME | timestamp(6) | YES | The maximum end time of the load balancing task.
NoteFor V4.3.x, this view was introduced in V4.3.4. For V4.2.x, this column was introduced in V4.2.4. |
| ZONE_UNIT_NUM_LIST | varchar(4096) | NO | The number of units in each zone of the tenant.
Note
|
| PARAMETER_LIST | longtext | NO | The parameters of the balancing-related configurations.
Note
|
References
View the history of log stream-level load balancing jobs (Job) for all tenants: CDB_OB_BALANCE_JOB_HISTORY
View the log stream-level load balancing tasks (Task) for all tenants:
View the tablet-level load balancing tasks (Task) for all tenants:
View the Transfer Partition tasks (Task) for all tenants:
For more information about data load balancing, see Data load balancing.