Note
This view is available starting with V4.1.0.
Purpose
This view displays the I/O resource configuration 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 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, with a value of 0-100. |
| MAX_IOPS | bigint(20) | NO | The IOPS upper limit semantics, with a value of 0-100. |
| WEIGHT_IOPS | bigint(20) | NO | The IOPS sharing semantics, with a value of 0-100. |
Sample query
Query the I/O resource configuration of the current tenant in the Resource Manager as the sys 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