Note
This view is available starting with V4.4.1.
Purpose
The V$OB_SS_OBJECT_TYPE_IO_STAT view displays the statistics of read, write, and delete operations on different types of objects for a tenant on the current node.
Note
This view is available only in Shared-Storage (SS) mode. In Shared-Nothing (SN) mode, the query result of this view is empty.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| OBJECT_TYPE | varchar(128) | NO | The type of the object. |
| MODE | varchar(32) | NO | The data source type. Valid values:
|
| READ_CNT | bigint(20) | NO | The total number of I/O read operations. |
| READ_SIZE | bigint(20) | NO | The total size of I/O read operations, in bytes. |
| READ_FAIL_CNT | bigint(20) | NO | The total number of failed I/O read operations. |
| READ_IOPS | bigint(20) | NO | The average IOPS of I/O read operations. |
| WRITE_CNT | bigint(20) | NO | The total number of I/O write operations. |
| WRITE_SIZE | bigint(20) | NO | The total size of I/O write operations, in bytes. |
| WRITE_FAIL_CNT | bigint(20) | NO | The total number of failed I/O write operations. |
| WRITE_IOPS | bigint(20) | NO | The average IOPS of I/O write operations. |
| DELETE_CNT | bigint(20) | NO | The total number of object delete operations. |
| DELETE_FAIL_CNT | bigint(20) | NO | The total number of failed object delete operations. |
| DELETE_IOPS | bigint(20) | NO | The IOPS of object delete operations. |
| READ_BANDWIDTH | bigint(20) | NO | The average I/O read bandwidth, in MB/s
NoteThis column is available starting with V4.6.0. |
| READ_BANDWIDTH_DISPLAY | varchar(29) | NO | The bandwidth in Human Readable format, for example, 10GB/s or 10MB/s
NoteThis column is available starting with V4.6.0. |
| READ_DELAY_US | bigint(20) | NO | The average I/O read delay, in us
NoteThis column is available starting with V4.6.0. |
| WRITE_BANDWIDTH | bigint(20) | NO | The average I/O write bandwidth, in MB/s
NoteThis column is available starting with V4.6.0. |
| WRITE_BANDWIDTH_DISPLAY | varchar(29) | NO | The bandwidth in Human Readable format, for example, 10GB/s or 10MB/s
NoteThis column is available starting with V4.6.0. |
| WRITE_DELAY_US | bigint(20) | NO | The average I/O write delay, in us
NoteThis column is available starting with V4.6.0. |
Sample query
Query the statistics of read, write, and delete operations on different types of objects for a tenant with the tenant ID of 1002 on the current node in the sys tenant.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.V$OB_SS_OBJECT_TYPE_IO_STAT WHERE tenant_id = 1002 LIMIT 10;
The query result is as follows:
+--------------+----------+-----------+-------------------------+-------+----------+-----------+---------------+-----------+-----------+------------+----------------+------------+------------+-----------------+-------------+----------------+------------------------+---------------+-----------------+-------------------------+----------------+
| SVR_IP | SVR_PORT | TENANT_ID | OBJECT_TYPE | MODE | READ_CNT | READ_SIZE | READ_FAIL_CNT | READ_IOPS | WRITE_CNT | WRITE_SIZE | WRITE_FAIL_CNT | WRITE_IOPS | DELETE_CNT | DELETE_FAIL_CNT | DELETE_IOPS | READ_BANDWIDTH | READ_BANDWIDTH_DISPLAY | READ_DELAY_US | WRITE_BANDWIDTH | WRITE_BANDWIDTH_DISPLAY | WRITE_DELAY_US |
+--------------+----------+-----------+-------------------------+-------+----------+-----------+---------------+-----------+-----------+------------+----------------+------------+------------+-----------------+-------------+----------------+------------------------+---------------+-----------------+-------------------------+----------------+
| xx.xx.xx.xx | 1624 | 1002 | PRIVATE_DATA_MACRO | local | 2509 | 3887000 | 0 | 4 | 816 | 3342336 | 0 | 0 | 0 | 0 | 0 | 2309 | 2.25KB/s | 499 | 819 | 819B/s | 247 |
| xx.xx.xx.xx | 1624 | 1002 | PRIVATE_META_MACRO | local | 10841 | 6003172 | 0 | 11 | 3428 | 14041088 | 0 | 2 | 0 | 0 | 0 | 6380 | 6.23KB/s | 230 | 8191 | 8.00KB/s | 304 |
| xx.xx.xx.xx | 1624 | 1002 | SHARED_MINI_DATA_MACRO | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0B/s | 0 | 0 | 0B/s | 0 |
| xx.xx.xx.xx | 1624 | 1002 | SHARED_MINI_META_MACRO | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0B/s | 0 | 0 | 0B/s | 0 |
| xx.xx.xx.xx | 1624 | 1002 | SHARED_MINOR_DATA_MACRO | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0B/s | 0 | 0 | 0B/s | 0 |
| xx.xx.xx.xx | 1624 | 1002 | SHARED_MINOR_META_MACRO | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0B/s | 0 | 0 | 0B/s | 0 |
| xx.xx.xx.xx | 1624 | 1002 | SHARED_MAJOR_DATA_MACRO | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0B/s | 0 | 0 | 0B/s | 0 |
| xx.xx.xx.xx | 1624 | 1002 | SHARED_MAJOR_META_MACRO | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0B/s | 0 | 0 | 0B/s | 0 |
| xx.xx.xx.xx | 1624 | 1002 | TMP_FILE | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0B/s | 0 | 0 | 0B/s | 0 |
| xx.xx.xx.xx | 1624 | 1002 | SERVER_META | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0B/s | 0 | 0 | 0B/s | 0 |
+--------------+----------+-----------+-------------------------+-------+----------+-----------+---------------+-----------+-----------+------------+----------------+------------+------------+-----------------+-------------+----------------+------------------------+---------------+-----------------+-------------------------+----------------+
10 rows in set (0.054 sec)