Note
This view is available starting with V4.3.4.
Purpose
This view displays the resource configuration parameters of the current tenant in the Resource Manager.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| PLAN | varchar(128) | NO | The name of the resource plan to which the resource plan content belongs. |
| GROUP_OR_SUBPLAN | varchar(128) | NO | The name of the resource group controlled by the resource plan content. |
| COMMENTS | varchar(2000) | YES | The comment corresponding to the resource plan content. |
| MGMT_P1 | bigint(20) | NO | The maximum CPU utilization relative to availability when the system is fully loaded. The default value is 100. |
| UTILIZATION_LIMIT | bigint(20) | NO | The upper limit of the percentage of CPU resources used by the resource group in the total CPU resources of the tenant. The default value is 100, indicating that the tenant can use up to 100% of its CPU resources. |
| MIN_IOPS | bigint(20) | NO | The reserved IOPS resources for the resource group when I/O contention occurs. The sum of all resource groups' specified MIN_IOPS values cannot exceed 100. The default value is 0. |
| MAX_IOPS | bigint(20) | NO | The maximum IOPS resources that the resource group can use. The sum of all resource groups' specified MAX_IOPS values can exceed 100. The default value is 100. |
| WEIGHT_IOPS | bigint(20) | NO | The weight value of IOPS when I/O resource contention occurs. The sum of all resource groups' specified WEIGHT_IOPS values can exceed 100. Under the premise of meeting the MIN_IOPS and MAX_IOPS settings, I/O resources will be allocated based on the normalized weight values. The default value is 0. |
| MAX_NET_BANDWIDTH | bigint(20) | NO | The upper limit of the network bandwidth used by the resource group. The sum of all resource groups' specified MAX_NET_BANDWIDTH values can exceed 100. The default value is 100. |
| NET_BANDWIDTH_WEIGHT | bigint(20) | NO | The weight of bandwidth when network resource contention occurs. The sum of all resource groups' specified NET_BANDWIDTH_WEIGHT values can exceed 100. Under the premise of meeting the MAX_NET_BANDWIDTH settings, network bandwidth resources will be allocated based on the normalized weight values. The default value is 0. |
Sample query
In SN (Shared-Nothing) mode, a user tenant queries the resource configuration parameters of the current 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
Query the resource configuration parameters of all tenants in the Resource Manager: CDB_OB_RSRC_DIRECTIVES
For more information about resource isolation configuration, see the following topics: