Note
This view is available starting with V5.0.1.
Overview
The GV$OB_TENANT_WORKER_GROUPS view displays the status of worker thread groups on all nodes of all tenants.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | Server IP Address |
| SVR_PORT | bigint(20) | NO | Server Port Number |
| TENANT_ID | bigint(20) | NO | Tenant ID |
| GROUP_ID | bigint(20) | NO | Resource Group ID |
| WORKERS_SIZE | bigint(20) | NO | Current Worker Threads |
| REQ_QUEUE_SIZE | bigint(20) | NO | Length of the normal request queue |
| RECV_REQ_CNT | bigint(20) | NO | Cumulative Number of Requests Received |
| DELETED | tinyint(4) | NO | Whether the resource group has been marked for deletion:
|
| TOKEN_CHANGE_TS | bigint(20) | NO | Timestamp of the last token change |
| THROTTLED_TIME_US | bigint(20) | NO | Cumulative Throttling Time, Unit: microseconds |
| IDLE_CNT | bigint(20) | NO | Number of Idle Worker Threads |
| LAST_NOT_EMPTY_TS | bigint(20) | NO | Timestamp of the last non-null value in the queue |
Sample query
In the sys tenant, query the status of worker thread groups on each node for the tenant with ID 1002.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.GV$OB_TENANT_WORKER_GROUPS WHERE TENANT_ID = 1002;
The query result is as follows:
+--------------+----------+-----------+----------+--------------+----------------+--------------+---------+------------------+-------------------+----------+-------------------+
| SVR_IP | SVR_PORT | TENANT_ID | GROUP_ID | WORKERS_SIZE | REQ_QUEUE_SIZE | RECV_REQ_CNT | DELETED | TOKEN_CHANGE_TS | THROTTLED_TIME_US | IDLE_CNT | LAST_NOT_EMPTY_TS |
+--------------+----------+-----------+----------+--------------+----------------+--------------+---------+------------------+-------------------+----------+-------------------+
| 6.xx.xxx.xxx | 2882 | 1002 | 28 | 0 | 0 | 350 | 0 | 1782355834008162 | 0 | 0 | 1782355836374608 |
| 6.xx.xxx.xxx | 2882 | 1002 | 18 | 1 | 0 | 123683 | 0 | 1782355794457835 | 23240301082688 | 1 | 1782355836374608 |
| 6.xx.xxx.xxx | 2882 | 1002 | 15 | 2 | 0 | 120 | 0 | 1782294217149143 | 0 | 2 | 1782355836374608 |
| 6.xx.xxx.xxx | 2882 | 1002 | 20 | 0 | 0 | 560 | 0 | 1782324063400986 | 0 | 0 | 1782324063400984 |
| 6.xx.xxx.xxx | 2882 | 1002 | 2 | 1 | 0 | 497306 | 0 | 1782293670813619 | 0 | 1 | 1782355836374608 |
+--------------+----------+-----------+----------+--------------+----------------+--------------+---------+------------------+-------------------+----------+-------------------+
5 rows in set