GV$OB_IO_BENCHMARK - OceanBase Database AI V4.6.2 | OceanBase 文档中心

文档反馈

V4.6.2

简介
部署
连接数据库
数据库模式设计
数据流转
数据加工
数据分支管理
AI 搜索
查询加速
管理数据库
参考指南
- 系统管理
- 数据库对象管理
- 数据库设计规范与约束
- 数据写入和读取
- 事务管理
- AI 函数服务
- SQL 参考
- PL 参考
- 系统视图
  - 系统视图概述
  - 系统视图总览
  - SYS 租户系统视图
    - 字典视图
    - 性能视图
      - GV$ACTIVE_SESSION_HISTORY
      - GV$DML_STATS
      - GV$LATCH
      - GV$OB_ACTIVE_SESSION_HISTORY
      - GV$OB_COMPACTION_DIAGNOSE_INFO
      - GV$OB_COMPACTION_PROGRESS
      - GV$OB_COMPACTION_SUGGESTIONS
      - GV$OB_CGROUP_CONFIG
      - GV$OB_DTL_INTERM_RESULT_MONITOR
      - GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
      - GV$OB_FLT_TRACE_CONFIG
      - GV$OB_FUNCTION_IO_STAT
      - GV$OB_GROUP_IO_STAT
      - GV$OB_HMS_CLIENT_POOL_STAT
      - GV$OB_HNSW_INDEX_INFO
      - GV$OB_HNSW_INDEX_SEGMENT_INFO
      - GV$OB_IO_BENCHMARK
      - GV$OB_IO_CALIBRATION_STATUS
      - GV$OB_IVF_INDEX_INFO
      - GV$OB_KVCACHE
      - GV$OB_KV_GROUP_COMMIT_STATUS
      - GV$OB_KV_CONNECTIONS
      - GV$OB_LOG_STAT
      - GV$OB_LOG_TRANSPORT_DEST_STAT
      - GV$OB_LS_SNAPSHOTS
      - GV$OB_MEMORY
      - GV$OB_MEMSTORE
      - GV$OB_MEMSTORE_INFO
      - GV$OB_MERGE_INFO
      - GV$OB_NIC_INFO
      - GV$OB_RPC_INCOMING
      - GV$OB_RPC_OUTGOING
      - GV$OB_PARAMETERS
      - GV$OB_PLAN_CACHE_PLAN_EXPLAIN
      - GV$OB_PLAN_CACHE_PLAN_STAT
      - GV$OB_PLAN_CACHE_STAT
      - GV$OB_PLUGINS
      - GV$OB_PROCESSLIST
      - GV$OB_PS_ITEM_INFO
      - GV$OB_PS_STAT
      - GV$OB_PX_P2P_DATAHUB
      - GV$OB_PX_TARGET_MONITOR
      - GV$OB_PX_WORKER_STAT
      - GV$OB_RES_MGR_SYSSTAT
      - GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
      - GV$OB_SERVER_SCHEMA_INFO
      - GV$OB_SERVERS
      - GV$OB_SERVER_STORAGE
      - GV$OB_SESS_TIME_MODEL
      - GV$OB_SESSION
      - GV$OB_SESSION_PS_INFO
      - GV$OB_SHARED_STORAGE_QUOTA
      - GV$OB_SINDI_INDEX_INFO
      - GV$OB_SQL_AUDIT
      - GV$OB_SQL_CCL_STATUS
      - GV$SQL_JOIN_FILTER
      - GV$OB_SQL_PLAN
      - GV$SQL_PLAN_MONITOR
      - GV$OB_SQL_WORKAREA_MEMORY_INFO
      - GV$OB_SQLSTAT
      - GV$OB_SSTABLES
      - GV$OB_LOCAL_CACHE
      - GV$OB_LOCAL_CACHE_DIAGNOSE
      - GV$OB_OBJECT_TYPE_IO_STAT
      - GV$OB_STORAGE_CACHE_TASKS
      - GV$OB_SYS_TIME_MODEL
      - GV$OB_TABLET_COMPACTION_HISTORY
      - GV$OB_TABLET_COMPACTION_PROGRESS
      - GV$OB_TABLET_LOCAL_CACHE
      - GV$OB_TABLET_REPLICA_INFO
      - GV$OB_TENANT_MEMORY
      - GV$OB_TENANT_RESOURCE_LIMIT
      - GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
      - GV$OB_TENANT_RUNTIME_INFO
      - GV$OB_TRANSACTION_PARTICIPANTS
      - GV$OB_TRANSACTION_SCHEDULERS
      - GV$OB_UNITS
      - GV$OB_VECTOR_MEMORY
      - GV$SESSION_EVENT
      - GV$SESSION_LONGOPS
      - GV$SESSION_WAIT
      - GV$SESSION_WAIT_HISTORY
      - GV$SESSTAT
      - GV$SQL_WORKAREA
      - GV$SQL_WORKAREA_ACTIVE
      - GV$SQL_WORKAREA_HISTOGRAM
      - GV$SYSSTAT
      - GV$SYSTEM_EVENT
      - GV$OB_ARBITRATION_MEMBER_INFO
      - GV$OB_ARBITRATION_SERVICE_STATUS
      - GV$OB_KV_CLIENT_INFO
      - GV$OB_LOCKS
      - GV$OB_OPT_STAT_GATHER_MONITOR
      - GV$OB_THREAD
      - GV$OB_PL_CACHE_OBJECT
      - V$OB_PL_CACHE_OBJECT
      - V$ACTIVE_SESSION_HISTORY
      - V$DML_STATS
      - V$ENCRYPTED_TABLESPACES
      - V$EVENT_NAME
      - V$LATCH
      - V$OB_ACTIVE_SESSION_HISTORY
      - V$OB_ARCHIVE_DEST_STATUS
      - V$OB_COMPACTION_DIAGNOSE_INFO
      - V$OB_COMPACTION_PROGRESS
      - V$OB_COMPACTION_SUGGESTIONS
      - V$OB_COMPATIBILITY_CONTROL
      - V$OB_CGROUP_CONFIG
      - V$OB_DTL_INTERM_RESULT_MONITOR
      - V$OB_DYNAMIC_PARTITION_TABLES
      - V$OB_ENCRYPTED_TABLES
      - V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
      - V$OB_FUNCTION_IO_STAT
      - V$OB_GROUP_IO_STAT
      - V$OB_HMS_CLIENT_POOL_STAT
      - V$OB_IO_BENCHMARK
      - V$OB_HNSW_INDEX_INFO
      - V$OB_HNSW_INDEX_SEGMENT_INFO
      - V$OB_IO_CALIBRATION_STATUS
      - V$OB_IVF_INDEX_INFO
      - V$OB_KVCACHE
      - V$OB_KV_CLIENT_INFO
      - V$OB_KV_GROUP_COMMIT_STATUS
      - V$OB_KV_CONNECTIONS
      - V$OB_LOG_STAT
      - V$OB_LOG_TRANSPORT_DEST_STAT
      - V$OB_LS_LOG_RESTORE_STATUS
      - V$OB_LS_REPLICA_TASK_PLAN
      - V$OB_LS_SNAPSHOTS
      - V$OB_MEMORY
      - V$OB_MEMSTORE
      - V$OB_MEMSTORE_INFO
      - V$OB_MERGE_INFO
      - V$OB_NIC_INFO
      - V$OB_RPC_INCOMING
      - V$OB_RPC_OUTGOING
      - V$OB_PARAMETERS
      - V$OB_PLAN_CACHE_PLAN_EXPLAIN
      - V$OB_PLAN_CACHE_PLAN_STAT
      - V$OB_PLAN_CACHE_STAT
      - V$OB_PLUGINS
      - V$OB_PROCESSLIST
      - V$OB_PS_ITEM_INFO
      - V$OB_PS_STAT
      - V$OB_PX_P2P_DATAHUB
      - V$OB_PX_TARGET_MONITOR
      - V$OB_PX_WORKER_STAT
      - V$OB_RES_MGR_SYSSTAT
      - V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
      - V$OB_SERVER_SCHEMA_INFO
      - V$OB_SERVERS
      - V$OB_SERVER_STORAGE
      - V$OB_SESS_TIME_MODEL
      - V$OB_SESSION
      - V$SESSION_EVENT
      - V$OB_SESSION_PS_INFO
      - V$OB_SHARED_STORAGE_QUOTA
      - V$OB_SINDI_INDEX_INFO
      - V$OB_SQL_AUDIT
      - V$OB_SQL_CCL_STATUS
      - V$SQL_JOIN_FILTER
      - V$OB_SQL_PLAN
      - V$OB_SQL_WORKAREA_MEMORY_INFO
      - V$OB_SQLSTAT
      - V$OB_SHARED_SSTABLES
      - V$OB_SSTABLES
      - V$OB_LOCAL_CACHE
      - V$OB_LOCAL_CACHE_DIAGNOSE
      - V$OB_OBJECT_TYPE_IO_STAT
      - V$OB_STORAGE_CACHE_TASKS
      - V$OB_SYS_TIME_MODEL
      - V$OB_TABLET_COMPACTION_HISTORY
      - V$OB_TABLET_COMPACTION_PROGRESS
      - V$OB_TABLET_LOCAL_CACHE
      - V$OB_TABLET_REPLICA_INFO
      - V$OB_TENANT_MEMORY
      - V$OB_TENANT_RESOURCE_LIMIT
      - V$OB_TENANT_RESOURCE_LIMIT_DETAIL
      - V$OB_TENANT_RUNTIME_INFO
      - V$OB_TIMESTAMP_SERVICE
      - V$OB_TRANSACTION_PARTICIPANTS
      - V$OB_TRANSACTION_SCHEDULERS
      - V$OB_UNITS
      - V$RSRC_PLAN
      - V$SESSION_LONGOPS
      - V$SESSION_WAIT
      - V$SESSION_WAIT_HISTORY
      - V$SESSTAT
      - V$SQL_MONITOR_STATNAME
      - V$SQL_PLAN_MONITOR
      - V$SQL_WORKAREA
      - V$SQL_WORKAREA_ACTIVE
      - V$SQL_WORKAREA_HISTOGRAM
      - V$STATNAME
      - V$SYSSTAT
      - V$SYSTEM_EVENT
      - V$OB_ARBITRATION_MEMBER_INFO
      - V$OB_ARBITRATION_SERVICE_STATUS
      - V$OB_LOCKS
      - V$OB_OPT_STAT_GATHER_MONITOR
      - V$OB_THREAD
      - V$OB_VECTOR_MEMORY
  - 用户租户系统视图
  - [监控项](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005682977)总览
  - 常见等待事件说明
- 配置项与系统变量
- 错误码
- 日志服务参考
- OBKV
- 性能调优
- 数据库代理
- 驱动
- 平台产品
- 组件 & 工具
- 数据库插件
版本发布记录

GV$OB_IO_BENCHMARK

更新时间：2026-08-13 19:27:48

分享

功能描述

展示所有节点上 I/O 模块使用的磁盘校准数据。

字段说明

字段名称	类型	是否可以为 NULL	描述
SVR_IP	varchar(46)	NO	服务器 IP 地址
SVR_PORT	bigint(20)	NO	服务器端口号
STORAGE_NAME	varchar(1024)	NO	存储名称，例如：DATA、REDO
MODE	varchar(256)	NO	I/O 模式，例如：READ、WRITE
SIZE	bigint(20)	NO	I/O 尺寸，单位为字节
IOPS	bigint(20)	NO	每秒钟完成 I/O 请求的数量
MBPS	bigint(20)	NO	磁盘带宽，单位为 MB/s
LATENCY	bigint(20)	NO	响应时间，单位为 us

查询示例

查看所有节点上 I/O 模块所使用的磁盘校准数据，展示前 10 条记录。

obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_IO_BENCHMARK LIMIT 10;

查询结果如下：

+----------------+----------+--------------+------+---------+--------+------+---------+
| SVR_IP         | SVR_PORT | STORAGE_NAME | MODE | SIZE    | IOPS   | MBPS | LATENCY |
+----------------+----------+--------------+------+---------+--------+------+---------+
| 172.xx.xxx.xxx |     2882 | DATA         | READ |    4096 | 126002 |  492 |     126 |
| 172.xx.xxx.xxx |     2882 | DATA         | READ |    8192 | 115242 |  900 |     138 |
| 172.xx.xxx.xxx |     2882 | DATA         | READ |   16384 | 109285 | 1707 |     146 |
| 172.xx.xxx.xxx |     2882 | DATA         | READ |   32768 |  88949 | 2779 |     179 |
| 172.xx.xxx.xxx |     2882 | DATA         | READ |   65536 |  68702 | 4293 |     232 |
| 172.xx.xxx.xxx |     2882 | DATA         | READ |  131072 |  48018 | 6002 |     332 |
| 172.xx.xxx.xxx |     2882 | DATA         | READ |  262144 |  29904 | 7476 |     534 |
| 172.xx.xxx.xxx |     2882 | DATA         | READ |  524288 |  16730 | 8365 |     956 |
| 172.xx.xxx.xxx |     2882 | DATA         | READ | 1048576 |   9077 | 9077 |    1762 |
| 172.xx.xxx.xxx |     2882 | DATA         | READ | 2097152 |   4770 | 9540 |    3355 |
+----------------+----------+--------------+------+---------+--------+------+---------+
10 rows in set

相关视图或文档

查看当前 OBServer 节点上 I/O 模块使用的磁盘校准数据：V$OB_IO_BENCHMARK
查看磁盘 I/O 校准状态：
- GV$OB_IO_CALIBRATION_STATUS
- V$OB_IO_CALIBRATION_STATUS
有关磁盘性能校准的详细操作，参见磁盘性能校准。

有帮助

无帮助