Note
This view is available starting with V4.3.4.
Purpose
This view displays the configuration parameters of various resource types for all tenants in the Resource Manager.
Columns
| Column | Type | Nullable? | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant to which the resource plan belongs. | ||||||||||
| PLAN | varchar(128) | NO | The name of the resource plan to which the content belongs. | ||||||||||
| COLUMN | TYPE | NULLABLE | DESCRIPTION | ------------ | -------------- | ---------- | ---------------------------- | GROUP_OR_SUBPLAN | varchar(128) | NO | Name of the resource group controlled by the resource plan. | ||
| COMMENTS | varchar(2000) | YES | Comments for resource plan content. | ||||||||||
| MGMT_P1 | bigint(20) | NO | The maximum CPU utilization as a percentage under system full load. Default value: 100. |
||||||||||
| UTILIZATION_LIMIT | bigint(20) | NO | Specifies the upper limit of the percentage of CPU resources used by the resource group relative to the total CPU resources of the tenant. The default value is 100, which means that the resource group can use all of the tenant's CPU resources. |
||||||||||
| MIN_IOPS | bigint(20) | NO | The IOPS resources reserved by a resource group when I/O contention occurs. The sum of MIN_IOPS values across all resource groups must be less than or equal to 100. Default value: 0 |
||||||||||
| MAX_IOPS | bigint(20) | NO | The maximum IOPS available to the resource group. The sum of the MAX_IOPS values specified for all resource groups can exceed 100. The default value is 100. |
||||||||||
| WEIGHT_IOPS | bigint(20) | NO | The IOPS weight value that determines I/O resource allocation when I/O resource contention occurs. The sum of all specified WEIGHT_IOPS values across resource groups can exceed 100, provided that the MIN_IOPS and MAX_IOPS parameters are set. The default value is 0. |
||||||||||
| MAX_NET_BANDWIDTH | bigint(20) | NO | The maximum network bandwidth used by the resource group. The sum of all specified MAX_NET_BANDWIDTH values of the resource groups can exceed 100. Default value: 100 |
||||||||||
| NET_BANDWIDTH_WEIGHT | bigint(20) | NO | The weight of network bandwidth when a network bandwidth resource contention occurs. The total sum of the NET_BANDWIDTH_WEIGHT values specified by all resource groups may exceed 100. The network bandwidth resource will be allocated according to the weight-normed value, provided that MAX_NET_BANDWIDTH is met. The default value is 0. |
Sample query
In Shared-Nothing mode, the sys tenant queries Resource Manager for configuration parameters of all tenants.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_RSRC_DIRECTIVES;
Query result
+-----------+---------+-------------------+-----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
| 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