Note
This view is available starting with V4.3.4.
Purpose
This view displays the I/O statistics of functions in the current tenant on the current OBServer node. When the resource group corresponding to the background task of the function does not enable the resource management plan, the displayed I/O information is only for reference, and the corresponding resources cannot be limited.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| FUNCTION_NAME | varchar(32) | NO | The name of the background task corresponding to the function:
|
| MODE | varchar(32) | NO | The I/O read/write mode. Shared storage requests are remote requests, and other types of requests are local requests:
|
| SIZE | bigint(20) | NO | The average I/O size. |
| REAL_IOPS | bigint(20) | NO | The actual IOPS. |
| REAL_MBPS | bigint(20) | NO | The actual bandwidth, in MB/s. |
| SCHEDULE_US | bigint(20) | NO | The average I/O scheduling time, in us. |
| IO_DELAY_US | bigint(20) | NO | The average disk I/O execution time, in us. |
| TOTAL_US | bigint(20) | NO | The overall average I/O execution time, in us. |
Sample query
Query the I/O statistics of the current tenant on the current OBServer node.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_FUNCTION_IO_STAT LIMIT 5;
The query result is as follows:
+----------------+----------+-----------+------------------+--------------+------+-----------+-----------+-------------+-------------+----------+
| SVR_IP | SVR_PORT | TENANT_ID | FUNCTION_NAME | MODE | SIZE | REAL_IOPS | REAL_MBPS | SCHEDULE_US | IO_DELAY_US | TOTAL_US |
+----------------+----------+-----------+------------------+--------------+------+-----------+-----------+-------------+-------------+----------+
| 172.xx.xxx.xxx | 2882 | 0 | DEFAULT_FUNCTION | LOCAL READ | 0 | 0 | 0 | 0 | 0 | 0 |
| 172.xx.xxx.xxx | 2882 | 0 | DEFAULT_FUNCTION | LOCAL WRITE | 4096 | 2 | 0 | 20 | 142 | 178 |
| 172.xx.xxx.xxx | 2882 | 0 | DEFAULT_FUNCTION | REMOTE READ | 0 | 0 | 0 | 20 | 142 | 178 |
| 172.xx.xxx.xxx | 2882 | 0 | DEFAULT_FUNCTION | REMOTE WRITE | 0 | 0 | 0 | 20 | 142 | 178 |
| 172.xx.xxx.xxx | 2882 | 0 | COMPACTION_HIGH | LOCAL READ | 0 | 0 | 0 | 20 | 142 | 178 |
+----------------+----------+-----------+------------------+--------------+------+-----------+-----------+-------------+-------------+----------+
5 rows in set
References
Query the I/O statistics of functions in the current tenant on all OBServer nodes: GV$OB_FUNCTION_IO_STAT
Query the real-time status of each resource group of the tenant:
For more information about resource isolation, see the following topics: