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 tenant unit slice. |
| TOKEN_CNT | bigint(20) | NO | The number of tokens allocated by the scheduler. One token corresponds to one worker thread. |
| ASS_TOKEN_CNT | bigint(20) | NO | The number of tokens currently confirmed by the tenant (confirmed based on token_cnt, generally 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 is calculated as 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 by 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: tenant worker thread cache + large request worker thread cache. |
| 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 the current node as the sys tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.V$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 | 227472 | 0 | 224 | 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 | 608202 | 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 | 608403 | 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 | 3474 | 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 | 582981 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
+----------------+----------+-----------+-------------+--------------+--------------+-------+--------------+-----------+---------------+-----------+----------------+---------+---------+-----------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+---------+---------+--------------------+----------------------+---------+---------+---------+---------+---------+---------+--------------+
8 rows in set