Note
This view is available starting with V4.4.1.
Purpose
The V$OB_SS_OBJECT_TYPE_IO_STAT view displays the read, write, and delete usage of different types of objects in 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 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 source of the statistics.
|
| READ_CNT | bigint(20) | NO | The total number of I/O reads. |
| READ_SIZE | bigint(20) | NO | The total size of I/O reads, in bytes. |
| READ_FAIL_CNT | bigint(20) | NO | The total number of failed I/O reads. |
| READ_IOPS | bigint(20) | NO | The average IOPS of I/O reads. |
| WRITE_CNT | bigint(20) | NO | The total number of I/O writes. |
| WRITE_SIZE | bigint(20) | NO | The total size of I/O writes, in bytes. |
| WRITE_FAIL_CNT | bigint(20) | NO | The total number of failed I/O writes. |
| WRITE_IOPS | bigint(20) | NO | The average IOPS of I/O writes. |
| DELETE_CNT | bigint(20) | NO | The total number of object deletions. |
| DELETE_FAIL_CNT | bigint(20) | NO | The total number of failed object deletions. |
| DELETE_IOPS | bigint(20) | NO | The IOPS of object deletions. |
Sample query
Query the read, write, and delete usage of different types of objects in tenant 1002 on the current node.
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 |
+--------------+----------+-----------+----------------------------------------+--------+----------+-----------+---------------+-----------+-----------+------------+----------------+------------+------------+-----------------+-------------+
| 6.xx.xxx.xxx | 1624 | 1002 | PRIVATE_DATA_MACRO | local | 4433 | 76896007 | 0 | 0 | 1036 | 31776768 | 0 | 0 | 0 | 0 | 0 |
| 6.xx.xxx.xxx | 1624 | 1002 | PRIVATE_META_MACRO | local | 6542 | 3381103 | 0 | 0 | 2336 | 9797632 | 0 | 0 | 0 | 0 | 0 |
| 6.xx.xxx.xxx | 1624 | 1002 | SHARED_MINI_DATA_MACRO | local | 9 | 183870 | 0 | 0 | 2 | 372736 | 0 | 0 | 0 | 0 | 0 |
| 6.xx.xxx.xxx | 1624 | 1002 | SHARED_MINI_META_MACRO | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 6.xx.xxx.xxx | 1624 | 1002 | SHARED_MINOR_DATA_MACRO | local | 153 | 21247181 | 0 | 0 | 35 | 27193344 | 0 | 0 | 0 | 0 | 0 |
| 6.xx.xxx.xxx | 1624 | 1002 | SHARED_MINOR_META_MACRO | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 6.xx.xxx.xxx | 1624 | 1002 | SHARED_MAJOR_DATA_MACRO | local | 107 | 1718682 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 6.xx.xxx.xxx | 1624 | 1002 | SHARED_MAJOR_META_MACRO | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 6.xx.xxx.xxx | 1624 | 1002 | TMP_FILE | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 6.xx.xxx.xxx | 1624 | 1002 | SERVER_META | local | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
+--------------+----------+-----------+----------------------------------------+--------+----------+-----------+---------------+-----------+-----------+------------+----------------+------------+------------+-----------------+-------------+
10 rows in set