Overview
Displays the resource configuration parameters of the current tenant in the Resource Manager.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| PLAN | varchar(128) | NO | Resource Plan Name |
| GROUP_OR_SUBPLAN | varchar(128) | NO | Resource group name controlled by the resource plan |
| COMMENTS | varchar(2000) | YES | Comments Corresponding to Resource Plan Items |
| MGMT_P1 | bigint(20) | NO | The maximum percentage of CPU resources that can be allocated to a system when it is fully loaded. The default value is 100 |
| UTILIZATION_LIMIT | bigint(20) | NO | The maximum percentage of the tenant's total CPU resources that can be allocated to the resource group. Default value: 100, indicating that the tenant can use all CPU resources. |
| MIN_IOPS | bigint(20) | NO | In the event of I/O contention, the reserved IOPS resources for the resource group, specified by all resource groups MIN_IOPS The sum of these values must not exceed 100. Default value: 0 |
| MAX_IOPS | bigint(20) | NO | The maximum IOPS resources that a resource group can use, specified for all resource groups. MAX_IOPS The sum of these values can exceed 100. The default value is 100 |
| WEIGHT_IOPS | bigint(20) | NO | The weight value of IOPS in case of I/O resource contention, specified for all resource groups. WEIGHT_IOPS The sum of these values can exceed 100. To meet the requirement, MIN_IOPS, MAX_IOPS With this setting enabled, I/O resources are allocated according to the normalized weight values. The default value is 0 |
| MAX_NET_BANDWIDTH | bigint(20) | NO | The upper limit of network bandwidth for resource groups. It is specified for all resource groups. MAX_NET_BANDWIDTH The sum of these values can exceed 100. The default value is 100 |
| NET_BANDWIDTH_WEIGHT | bigint(20) | NO | The bandwidth weight in case of network resource contention, specified for all resource groups. NET_BANDWIDTH_WEIGHT The sum of these values can exceed 100. To meet the requirement, MAX_NET_BANDWIDTH If this parameter is not set, network bandwidth resources will be allocated according to the normalized weight values. The default value is 0 |
Sample query
In the SN (Shared-Nothing) mode, you can view the resource configuration parameters of your tenant in the Resource Manager.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_RSRC_DIRECTIVES;
The query result is as follows:
+---------+-------------------+----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
| PLAN | GROUP_OR_SUBPLAN | COMMENTS | MGMT_P1 | UTILIZATION_LIMIT | MIN_IOPS | MAX_IOPS | WEIGHT_IOPS | MAX_NET_BANDWIDTH | NET_BANDWIDTH_WEIGHT |
+---------+-------------------+----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
| daytime | batch_group | | 100 | 40 | 40 | 80 | 70 | 100 | 0 |
| daytime | interactive_group | new | 40 | 60 | 40 | 80 | 70 | 30 | 30 |
+---------+-------------------+----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
2 rows in set
References
View the resource configuration parameters of all tenants in the Resource Manager: CDB_OB_RSRC_DIRECTIVES
For detailed configuration operations on resource isolation, see the following topics: