Note
This view is available starting with V4.3.4.
Purpose
This view displays the various types of resource configuration parameters for all tenants in the Resource Manager.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Resource plan tenant ID |
| PLAN | varchar(128) | NO | The name of the resource plan to which the plan contents belong. |
| GROUP_OR_SUBPLAN | varchar(128) | NO | The name of the resource group controlled by resource plan content. |
| COMMENTS | varchar(2000) | YES | Comments for resource plans |
| MGMT_P1 | bigint(20) | NO | The relative maximum CPU utilization of the system when the system is under load. The default value is 100. |
| UTILIZATION_LIMIT | bigint(20) | NO | The maximum percentage of the total tenant CPU resources that can be used by the resource group. The default value is 100, which means the tenant can use all of its CPU resources. |
| MIN_IOPS | bigint(20) | NO | The IOPS reserved by the resource group when an I/O bottleneck occurs. The sum of all MIN_IOPS values specified across resource groups must not exceed 100. The default value is 0. |
| MAX_IOPS | bigint(20) | NO | The maximum IOPS resources that can be used for the resource group. The sum of all specified MAX_IOPS values for the resource groups can exceed 100. Default value: 100 |
| WEIGHT_IOPS | bigint(20) | NO | Specifies the weight of IOPS resources. If the weighted sum of WEIGHT_IOPS values in all resource groups exceeds 100, the IOPS resources are allocated in proportion to their weights. 0 is the default value. |
| MAX_NET_BANDWIDTH | bigint(20) | NO | The upper limit of the network bandwidth for the resource group. The total of the MAX_NET_BANDWIDTH of all resource groups can exceed 100. Default value: 100 |
| NET_BANDWIDTH_WEIGHT | bigint(20) | NO | The weight for network resources when there is a contention. The sum of NET_BANDWIDTH_WEIGHT specified by all resource groups can exceed 100. Within the limit of MAX_NET_BANDWIDTH, the network bandwidth resources are allocated according to the weight normalization. Default value: 0 |
Sample query
In Shared-Nothing mode, the sys tenant can view the resource configuration parameters of all tenants in the Resource Manager.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_RSRC_DIRECTIVES;
The query result is as follows:
+-----------+---------+-------------------+-----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
| TENANT_ID | PLAN | GROUP_OR_SUBPLAN | COMMENTS | MGMT_P1 | UTILIZATION_LIMIT | MIN_IOPS | MAX_IOPS | WEIGHT_IOPS | MAX_NET_BANDWIDTH | NET_BANDWIDTH_WEIGHT |
+-----------+---------+-------------------+-----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
| 1002 | daytime | batch_group | | 100 | 40 | 40 | 80 | 70 | 100 | 0 |
| 1002 | daytime | interactive_group | new | 40 | 60 | 40 | 80 | 70 | 30 | 30 |
| 1004 | PLAN_A | BIG_GROUP | new | 40 | 60 | 20 | 100 | 10 | 60 | 60 |
| 1004 | PLAN_A | SMALL_GROUP | AP Priority | 100 | 100 | 10 | 90 | 30 | 100 | 0 |
+-----------+---------+-------------------+-----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
4 rows in set
References
To view the resource configuration parameters of the current tenant in the Resource Manager, see DBA_OB_RSRC_DIRECTIVES.
For more information about resource isolation, see the following topics: