Overview
The V$OB_TENANT_RESOURCE_LIMIT view displays the logical resource usage, upper limits, effective constraints, and maximum usage after a crash restart for all tenants on the current OBServer node.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | IP Address of OBServer |
| SVR_PORT | bigint(20) | NO | RPC Port of OBServer |
| TENANT_ID | bigint(20) | NO | Tenant ID |
| ZONE | varchar(128) | NO | Name of the zone |
| RESOURCE_NAME | varchar(128) | NO | Resource Name |
| CURRENT_UTILIZATION | bigint(20) | NO | Current Resource Usage |
| MAX_UTILIZATION | bigint(20) | NO | Maximum resource usage after the server starts |
| RESERVED_VALUE | bigint(20) | NO | The amount of memory pre-allocated, which is the most fundamental guarantee for stable operation. |
| LIMIT_VALUE | bigint(20) | NO | Maximum Allowable Usage |
| EFFECTIVE_LIMIT_TYPE | varchar(128) | NO | Effective limit type, such as parameter, memory, CPU, disk, and so on. |
Sample query
Query the logical resource usage, upper limit, effective constraints, and maximum usage after a crash restart for all tenants on this OBServer.
obclient[oceanbase]> SELECT * FROM oceanbase.V$OB_TENANT_RESOURCE_LIMIT;
The query result is as follows:
+----------------+----------+-----------+-------+---------------+---------------------+-----------------+----------------+-------------+----------------------+
| SVR_IP | SVR_PORT | TENANT_ID | ZONE | RESOURCE_NAME | CURRENT_UTILIZATION | MAX_UTILIZATION | RESERVED_VALUE | LIMIT_VALUE | EFFECTIVE_LIMIT_TYPE |
+----------------+----------+-----------+-------+---------------+---------------------+-----------------+----------------+-------------+----------------------+
| xx.xx.xx.xx | 2882 | 1 | zone1 | ls | 1 | 1 | 0 | 32 | clog_disk |
| xx.xx.xx.xx | 2882 | 1 | zone1 | tablet | 960 | 960 | 0 | 325000 | configuration |
| xx.xx.xx.xx | 2882 | 1001 | zone1 | ls | 1 | 1 | 0 | 3 | clog_disk |
| xx.xx.xx.xx | 2882 | 1001 | zone1 | tablet | 885 | 885 | 0 | 20000 | configuration |
| xx.xx.xx.xx | 2882 | 1002 | zone1 | ls | 3 | 3 | 0 | 8 | memory |
| xx.xx.xx.xx | 2882 | 1002 | zone1 | tablet | 736 | 826 | 0 | 80000 | configuration |
| xx.xx.xx.xx | 2882 | 1003 | zone1 | ls | 1 | 1 | 0 | 3 | clog_disk |
| xx.xx.xx.xx | 2882 | 1003 | zone1 | tablet | 885 | 885 | 0 | 20000 | configuration |
+----------------+----------+-----------+-------+---------------+---------------------+-----------------+----------------+-------------+----------------------+
10 rows in set