Note
- For V4.3.x, it is available starting from V4.3.4.
- For V4.2.x, it is available starting from V4.2.5.
Overview
In the sys tenant, the V$OB_KV_GROUP_COMMIT_STATUS view provides access to the group commit status information for all OBKV tenant client connections on the current node.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | IP address of the node where the group commit group resides |
| SVR_PORT | bigint(20) | NO | Port number of the node where the group commit group resides |
| TENANT_ID | bigint(20) | NO | Tenant ID:
|
| TABLE_ID | bigint(20) | NO | ID of the table to which the group belongs. |
| LS_ID | bigint(20) | NO | LS ID of the group to which the commit group belongs |
| SCHEMA_VERSION | bigint(20) | NO | Schema version of the table to which the group belongs |
| GROUP_TYPE | varchar(32) | NO | Type of the group to be submitted. Currently supported queue types:
|
| QUEUE_SIZE | bigint(20) | NO | The size of the request queue in a group submission, representing the number of unconsumed requests. |
| BATCH_SIZE | bigint(20) | NO | The size of a batch in a group commit. |
| CREATE_TIME | timestamp(6) | NO | The time when the group was created during batch commit. |
| UPDATE_TIME | timestamp(6) | NO | The time when the status information of the group is refreshed during group commit |
Sample query
Query the group commit status information of the current node's OBKV tenant client connections, displaying records from the first day.
obclient > SELECT * FROM oceanbase.V$OB_KV_GROUP_COMMIT_STATUS limit 2;
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 | 1 | -1 | -1 | -1 | FAIL | 0 | 1 | 2024-10-15 14:35:03.595659 | 2024-10-15 14:35:03.595659 |
| xxx.xxx.xxx.xxx | 2882 | 1001 | -1 | -1 | -1 | FAIL | 0 | 1 | 2024-10-15 14:39:59.364065 | 2024-10-15 14:39:59.364065 |
+-----------------+----------+-----------+----------+-------+----------------+------------+------------+------------+----------------------------+----------------------------+
2 rows in set (0.010 sec)