Note
This view is available starting with V4.1.0.
Purpose
This view displays the IO resource configuration in Resource Manager.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| PLAN | varchar(128) | NO | The name of the resource plan to which the directive belongs. |
| GROUP_OR_SUBPLAN | varchar(128) | NO | The name of the resource group controlled by the directive. |
| COMMENTS | varchar(2000) | YES | The remarks of the resource plan. |
| MIN_IOPS | bigint(20) | NO | The IOPS reservation semantics, which can be 0-100. |
| MAX_IOPS | bigint(20) | NO | The IOPS upper limit semantics, which can be 0-100. |
| WEIGHT_IOPS | bigint(20) | NO | The IOPS sharing semantics, which can be 0-100. |
Sample query
Query the IO resource configuration in Resource Manager for the current user tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_RSRC_IO_DIRECTIVES;
The query result is as follows:
+---------+------------------+----------+----------+----------+-------------+
| PLAN | GROUP_OR_SUBPLAN | COMMENTS | MIN_IOPS | MAX_IOPS | WEIGHT_IOPS |
+---------+------------------+----------+----------+----------+-------------+
| daytime | batch_group | | 40 | 80 | 70 |
+---------+------------------+----------+----------+----------+-------------+
1 row in set