Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the resource configuration parameters of this 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 for the resource plan content. |
| MGMT_P1 | bigint(20) | NO | The maximum CPU usage ratio, as a percentage, that the system can achieve when it is fully loaded. The default value is 100. |
| UTILIZATION_LIMIT | bigint(20) | NO | The maximum percentage of CPU resources that a resource group can use out of the total CPU resources of the tenant. The default value is 100, indicating that the resource group can use all the CPU resources of the tenant. |
| MIN_IOPS | bigint(20) | NO | The IOPS resources reserved for the resource group when I/O contention occurs. The total value of MIN_IOPS specified for all resource groups cannot exceed 100. The default value is 0. |
| MAX_IOPS | bigint(20) | NO | The maximum IOPS resources that a resource group can use. The total value of MAX_IOPS specified for all resource groups can exceed 100. The default value is 100. |
| WEIGHT_IOPS | bigint(20) | NO | The weight value of IOPS in the case of I/O resource contention. The total value of WEIGHT_IOPS specified for all resource groups can exceed 100. I/O resources are allocated based on the normalized weights of WEIGHT_IOPS only when the MIN_IOPS and MAX_IOPS settings are met. The default value is 0. |
| MAX_NET_BANDWIDTH | bigint(20) | NO | The upper limit of the network bandwidth that a resource group can use. The total value of MAX_NET_BANDWIDTH specified for all resource groups can exceed 100. The default value is 100. |
| NET_BANDWIDTH_WEIGHT | bigint(20) | NO | The weight value of network bandwidth in the case of network resource contention. The total value of NET_BANDWIDTH_WEIGHT specified for all resource groups can exceed 100. Network bandwidth resources are allocated based on the normalized weights of NET_BANDWIDTH_WEIGHT only when the MAX_NET_BANDWIDTH setting is met. The default value is 0. |