Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
The GV$OB_IO_CALIBRATION_STATUS view displays the execution status of the I/O calibration task on all nodes.
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. |
| STORAGE_NAME | varchar(1024) | NO | The storage name, for example, DATA or REDO. |
| STATUS | varchar(256) | NO | The I/O calibration status. Valid values: |
| START_TIME | timestamp(6) | NO | The start time of the last I/O calibration. |
| FINISH_TIME | timestamp(6) | NO | The end time of the last I/O calibration. |
Sample query
Query the status of I/O calibration tasks on all nodes.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_IO_CALIBRATION_STATUS;
The query result is as follows:
+----------------+----------+--------------+--------+----------------------------+----------------------------+
| SVR_IP | SVR_PORT | STORAGE_NAME | STATUS | START_TIME | FINISH_TIME |
+----------------+----------+--------------+--------+----------------------------+----------------------------+
| 172.xx.xxx.xxx | 2882 | DATA | READY | 2025-01-02 10:20:23.299385 | 2025-01-02 10:22:03.578395 |
| 172.xx.xxx.xxx | 2882 | DATA | READY | 2025-01-02 10:20:23.299880 | 2025-01-02 10:22:03.590106 |
| 172.xx.xxx.xxx | 2882 | DATA | READY | 2025-01-02 10:20:23.300319 | 2025-01-02 10:22:03.589117 |
+----------------+----------+--------------+--------+----------------------------+----------------------------+
3 rows in set
References
To view the status of I/O calibration tasks on the current OBServer node, see V$OB_IO_CALIBRATION_STATUS.
To view the calibration data, see either of the following views:
For more information about how to calibrate disk performance, see Calibrate disk performance.