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 the available CPU resources when the system is fully loaded. The default value is 100. |
| UTILIZATION_LIMIT | bigint(20) | NO | The maximum percentage of CPU resources that the resource group can use. The default value is 100, which indicates that the resource group can use all CPU resources of the tenant. |
| MIN_IOPS | bigint(20) | NO | The reserved IOPS resources for the resource group when I/O contention occurs. The sum of all MIN_IOPS values of the resource groups 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 MAX_IOPS values of the resource groups can exceed 100. The default value is 100. |
| WEIGHT_IOPS | bigint(20) | NO | The weight of IOPS when I/O contention occurs. The sum of all WEIGHT_IOPS values of the resource groups can exceed 100. Under the premise of meeting the MIN_IOPS and MAX_IOPS settings, I/O resources are allocated based on the normalized weight. The default value is 0. |
| MAX_NET_BANDWIDTH | bigint(20) | NO | The maximum network bandwidth that the resource group can use. The sum of all MAX_NET_BANDWIDTH values of the resource groups can exceed 100. The default value is 100. |
| NET_BANDWIDTH_WEIGHT | bigint(20) | NO | The weight of bandwidth when network resources are in contention. The sum of all NET_BANDWIDTH_WEIGHT values of the resource groups can exceed 100. Under the premise of meeting the MAX_NET_BANDWIDTH setting, network bandwidth resources are allocated based on the normalized weight. The default value is 0. |
Sample query
In the Shared-Nothing architecture, a user tenant queries the resource configuration parameters of the 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, see the following topics: