Note
This view is available starting with V4.4.1.
Purpose
The GV$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 all nodes.
Note
This view is available only in the Shared-Storage (SS) mode. In the Shared-Nothing (SN) mode, the query result 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 deletion operations. |
| DELETE_FAIL_CNT | bigint(20) | NO | The total number of failed object deletion operations. |
| DELETE_IOPS | bigint(20) | NO | The IOPS of object deletion 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 a human-readable format, for example, 10 GB/s or 10 MB/s
NoteThis column is available starting with V4.6.0. |
| READ_DELAY_US | bigint(20) | NO | The average I/O read delay, in microseconds.
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 a human-readable format, for example, 10 GB/s or 10 MB/s
NoteThis column is available starting with V4.6.0. |
| WRITE_DELAY_US | bigint(20) | NO | The average I/O write delay, in microseconds.
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 all nodes.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.GV$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 | 2521 | 3895113 | 0 | 0 | 816 | 3342336 | 0 | 0 | 0 | 0 | 0 | 0 | 0B/s | 0 | 0 | 0B/s | 0 |
| xx.xx.xx.xx | 1624 | 1002 | PRIVATE_META_MACRO | local | 11678 | 6859303 | 0 | 0 | 3434 | 14065664 | 0 | 0 | 0 | 0 | 0 | 0 | 0B/s | 0 | 0 | 0B/s | 0 |
| 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.038 sec)