Note
This view is available starting with V4.2.1.
Purpose
This view displays information about the queue and thread limits in the tenant threads on the current OBServer node.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| COMPAT_MODE | bigint(20) | NO | The compatibility mode of the tenant. |
| UNIT_MIN_CPU | double | NO | The minimum number of CPU cores. |
| UNIT_MAX_CPU | double | NO | The maximum number of CPU cores. |
| SLICE | double | NO | The size of the tenant unit slice. |
| REMAIN_SLICE | double | NO | The remaining size of the slice. |
| ASS_TOKEN_CNT | bigint(20) | NO | The number of tokens currently confirmed for the tenant (equal to token_cnt). |
| LQ_TOKENS | bigint(20) | NO | The number of large query tokens. |
| USED_LQ_TOKENS | bigint(20) | NO | The number of workers holding large query tokens. |
| STOPPED | bigint(20) | NO | Indicates whether the tenant unit is being deleted. |
| IDLE_US | bigint(20) | NO | The total idle time of worker threads in a round (10 seconds). Idle time refers to the time spent waiting in the queue. |
| RECV_HP_RPC_CNT | bigint(20) | NO | The total number of High-level RPC requests received by the tenant. |
| RECV_NP_RPC_CNT | bigint(20) | NO | The total number of Normal-level RPC requests received by the tenant. |
| RECV_LP_RPC_CNT | bigint(20) | NO | The total number of Low-level RPC requests received by the tenant. |
| RECV_MYSQL_CNT | bigint(20) | NO | The total number of MySQL requests received by the tenant. |
| RECV_TASK_CNT | bigint(20) | NO | The total number of internal tasks received by the tenant. |
| RECV_LARGE_REQ_CNT | bigint(20) | NO | The total number of large requests predicted for the tenant. This value only increases and does not reset to zero. It increases during retries. |
| RECV_LARGE_QUERIES | bigint(20) | NO | The total number of large queries received by the tenant. |
| ACTIVES | bigint(20) | NO | The number of active worker threads. This value is generally equal to the number of workers. The difference includes the tenant worker thread cache and the large request cache with worker threads. |
| WORKERS | bigint(20) | NO | The number of worker threads held by the tenant. This value is the size of the workers_ list. |
| LQ_WAITING_WORKERS | bigint(20) | NO | The number of worker threads waiting for large queries. |
| REQ_QUEUE_TOTAL_SIZE | bigint(20) | NO | The total size of the request queue. |
| QUEUE_0 | bigint(20) | NO | The size of queue 0. |
| QUEUE_1 | bigint(20) | NO | The size of queue 1. |
| QUEUE_2 | bigint(20) | NO | The size of queue 2. |
| QUEUE_3 | bigint(20) | NO | The size of queue 3. |
| QUEUE_4 | bigint(20) | NO | The size of queue 4. |
| QUEUE_5 | bigint(20) | NO | The size of queue 5. |
| LARGE_QUEUED | bigint(20) | NO | The number of queued large requests. |
Sample query
Query the information about the queue and thread limits in the tenant threads on all nodes as the sys tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_TENANT_RUNTIME_INFO;
The query result is as follows:
+----------------+----------+-----------+-------------+--------------+--------------+-------+--------------+-----------+---------------+-----------+----------------+---------+---------+-----------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+---------+---------+--------------------+----------------------+---------+---------+---------+---------+---------+---------+--------------+
| SVR_IP | SVR_PORT | TENANT_ID | COMPAT_MODE | UNIT_MIN_CPU | UNIT_MAX_CPU | SLICE | REMAIN_SLICE | TOKEN_CNT | ASS_TOKEN_CNT | LQ_TOKENS | USED_LQ_TOKENS | STOPPED | IDLE_US | RECV_HP_RPC_CNT | RECV_NP_RPC_CNT | RECV_LP_RPC_CNT | RECV_MYSQL_CNT | RECV_TASK_CNT | RECV_LARGE_REQ_CNT | RECV_LARGE_QUERIES | ACTIVES | WORKERS | LQ_WAITING_WORKERS | REQ_QUEUE_TOTAL_SIZE | QUEUE_0 | QUEUE_1 | QUEUE_2 | QUEUE_3 | QUEUE_4 | QUEUE_5 | LARGE_QUEUED |
+----------------+----------+-----------+-------------+--------------+--------------+-------+--------------+-----------+---------------+-----------+----------------+---------+---------+-----------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+---------+---------+--------------------+----------------------+---------+---------+---------+---------+---------+---------+--------------+
| 11.xxx.xxx.xxx | 28825 | 1 | 0 | 1 | 1 | 0 | 0 | 12 | 12 | 0 | 0 | 0 | 0 | 381 | 227456 | 0 | 223 | 13 | 0 | 1861 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 11.xxx.xxx.xxx | 28825 | 508 | 0 | 5 | 5 | 0 | 0 | 52 | 52 | 0 | 0 | 0 | 0 | 0 | 174 | 0 | 0 | 0 | 0 | 0 | 52 | 52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 11.xxx.xxx.xxx | 28825 | 1001 | 0 | 1 | 1 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 471 | 3612 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 11.xxx.xxx.xxx | 28825 | 1002 | 0 | 1 | 1 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 25 | 608161 | 0 | 138 | 13 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 11.xxx.xxx.xxx | 28825 | 1003 | 0 | 1 | 1 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 231 | 3626 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 11.xxx.xxx.xxx | 28825 | 1004 | 1 | 1 | 1 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 232 | 608362 | 0 | 98 | 7 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 11.xxx.xxx.xxx | 28825 | 1005 | 0 | 1 | 1 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 369 | 3473 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 11.xxx.xxx.xxx | 28825 | 1006 | 0 | 1 | 1 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 9 | 582940 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
+----------------+----------+-----------+-------------+--------------+--------------+-------+--------------+-----------+---------------+-----------+----------------+---------+---------+-----------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+---------+---------+--------------------+----------------------+---------+---------+---------+---------+---------+---------+--------------+
8 rows in set