Note
- For OceanBase Database V4.3.x, this view was introduced in OceanBase Database V4.3.4.
- For OceanBase Database V4.2.x, this view was introduced in OceanBase Database V4.2.5.
Purpose
The GV$OB_KV_GROUP_COMMIT_STATUS view displays the group commit status on all OBServer nodes in the current OBKV tenant. You can query this view from a MySQL tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node where the group in the group commit resides. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node where the group in the group commit resides. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. Valid values: 1: indicates the ID of the sys tenant. |
| TABLE_ID | bigint(20) | NO | The ID of the table to which the group in the group commit belongs. |
| LS_ID | bigint(20) | NO | The ID of the log stream to which the group in the group commit belongs. |
| SCHEMA_VERSION | bigint(20) | NO | The schema version of the table to which the group in the group commit belongs. |
| GROUP_TYPE | varchar(32) | NO | The type of the group in the group commit. It indicates the type of the request queue in the group. Valid values:
|
| QUEUE_SIZE | bigint(20) | NO | The size of the request queue in the group in the group commit. It indicates the number of requests that have not been consumed. |
| BATCH_SIZE | bigint(20) | NO | The size of the batch in the group in the group commit. |
| CREATE_TIME | timestamp(6) | NO | The time when the group was created in the group commit. |
| UPDATE_TIME | timestamp(6) | NO | The time when the status of the group was last updated in the group commit. |
Sample query
obclient > SELECT * FROM oceanbase.GV$OB_KV_GROUP_COMMIT_STATUS limit 1;
The query result is as follows:
+-----------------+----------+-----------+----------+-------+----------------+------------+------------+------------+----------------------------+----------------------------+
| SVR_IP | SVR_PORT | TENANT_ID | TABLE_ID | LS_ID | SCHEMA_VERSION | GROUP_TYPE | QUEUE_SIZE | BATCH_SIZE | CREATE_TIME | UPDATE_TIME |
+-----------------+----------+-----------+----------+-------+----------------+------------+------------+------------+----------------------------+----------------------------+
| xxx.xxx.xxx.xxx | 2882 | 1002 | -1 | -1 | -1 | FAIL | 0 | 1 | 2024-10-15 14:39:59.254693 | 2024-10-15 14:39:59.254693 |
+-----------------+----------+-----------+----------+-------+----------------+------------+------------+------------+----------------------------+----------------------------+
1 rows in set (0.010 sec)