--- title: github-fill description: GV$OB_KV_CLIENT_INFO 说明 该视图从 V4.3.4 版本开始引入，主要适用于 OBKV-Table 客户端。 功能描述 在 MySQL 租户下，视图 GV$OB_KV_CLIENT_INFO 可以访问本 OBKV 租户客户端连接的配置参数信息。 字段说明 字段名称 类型 是否可以为 NULL 描述… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.3.5 LTS # GV$OB_KV_CLIENT_INFO 更新时间：2026-07-13 22:33:26 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.3.5/zh-CN/700.reference/700.system-views/400.system-view-of-mysql-mode/300.performance-view-of-mysql-mode/1250.gv-ob_kv_client_info-of-mysql-tenant.md) #### 说明 该视图从 V4.3.4 版本开始引入，主要适用于 OBKV-Table 客户端。 ## 功能描述 在 MySQL 租户下，视图 `GV$OB_KV_CLIENT_INFO` 可以访问本 OBKV 租户客户端连接的配置参数信息。 ## 字段说明 | **字段名称** | **类型** | **是否可以为 NULL** | **描述** | | --- | --- | --- | --- | | client_id | bigint | NO | 客户端 ID | | client_ip | varchar:MAX_IP_ADDR_LENGTH | NO | 客户端 IP 地址 | | client_port | bigint | NO | 客户端端口 | | svr_ip | varchar:MAX_IP_ADDR_LENGTH | NO | 所在服务端 IP 地址 | | svr_port | bigint | NO | 所在服务端端口 | | tenant_id | bigint | NO | 租户 ID | | user_name | varchar::OB_MAX_USER_NAME_LENGTH | NO | 用户名 | | first_login_ts | timestamp(6) | NO | 第一次登录时间 | | last_login_ts | timestamp(6) | NO | 上次登录时间 | | client_info | varchar:2048 | NO | 客户端信息 JSON 字符串 | `client_info` 字段 JSON 字符串格式如下： ```json { "client_id": 242153145, "runtime": { "rpc.execute.timeout": "3000", "rpc.operation.timeout": "10000", "runtime.max.wait": "3000", "runtime.retry.interval": "1", "runtime.retry.times": "1", "connection.max.expired.time": "8" }, "log": { "slow.query.monitor.threshold": "10" }, "route": { "metadata.refresh.interval": "60000", "continuous.failure.ceiling": "100", "server.address.caching.timeout": "3600000", "server.address.priority.timeout": "1800000", "table.entry.acquire.connect.timeout": "500", "table.entry.acquire.socket.timeout": "3000", "table.entry.refresh.interval.base": "100", "table.entry.refresh.interval.ceiling": "1600", "table.entry.refresh.try.times": "3" }, "thread_pool": { "runtime.batch.executor": "false" } } ``` JSON 字段中参数说明如下： | **参数** | **默认值** | **描述** | | --- | --- | --- | | metadata.refresh.interval | 60000 | 刷新 METADATA 的时间间隔。 | | rpc.execute.timeout | 3000 | 执行 RPC 请求的 socket 超时时间。 | | rpc.operation.timeout | 10000 | OceanBase 内部执行 RPC 请求的超时时间。 | | runtime.continuous.failure.ceiling | 100 | 连续运行失败上限，会刷新 TABLE 的地址。 | | runtime.max.wait | 3000 | 单次执行超时时间会在超时时间内重试。 | | runtime.retry.interval | 1 | 运行出错时重试的时间间隔。 | | runtime.retry.times | 1 | 运行过程中遇到可重试错误时的重试次数。 | | server.address.caching.timeout | 3600000L | SERVER 地址缓存的失效时间。 | | server.address.priority.timeout | 1800000L | SERVER 地址优先级的失效时间。 | | slow.query.monitor.threshold | 10 | 记录到 MONITOR 日志中的慢操作的运行时间阈值。 | | table.entry.acquire.connect.timeout | 500 | 刷新 TABLE 地址请求创建连接的超时时间。 | | table.entry.acquire.socket.timeout | 3000 | 刷新 TABLE 地址的 SOCKET 超时时间。 | | table.entry.refresh.interval.base | 100 | 刷新 TABLE 地址的基础时间间隔。 | | table.entry.refresh.interval.ceiling | 1600 | 刷新 TABLE 地址的最大时间间隔。 | | table.entry.refresh.try.times | 3 | 刷新 TABLE 地址的尝试次数。 | | runtime.batch.executor | false | 批量请求时并发执行的线程池 | | connection.max.expired.time | 8 | 客户端连接刷新重新登录的最大时间间隔 | ## 查询示例 在 MySQL 租户中查询视图 `GV$OB_KV_CLIENT_INFO` 的语句为： ```shell obclient [mysql]> SELECT * FROM oceanbase.GV$OB_KV_CLIENT_INFO LIMIT 1; ``` 返回结果示例如下： ```shell +---------------------+--------------+-------------+--------------+----------+-----------+-----------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | CLIENT_ID | CLIENT_IP | CLIENT_PORT | SVR_IP | SVR_PORT | TENANT_ID | USER_NAME | FIRST_LOGIN_TS | LAST_LOGIN_TS | CLIENT_INFO | +---------------------+--------------+-------------+--------------+----------+-----------+-----------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 7409156147904779098 | xx.xx.xx.xx | 46318 | xx.xx.xx.xx | 2882 | 1010 | ots_user | 2026-02-11 15:47:51.336915 | 2026-02-11 16:03:51.344704 | {"route":{"metadata.refresh.interval":"60000","table.entry.refresh.try.times":"3","table.entry.acquire.socket.timeout":"3000","runtime.continuous.failure.ceiling":"100","server.address.priority.timeout":"1800000","server.address.caching.timeout":"3600000","table.entry.refresh.interval.ceiling":"1600","table.entry.acquire.connect.timeout":"500","table.entry.refresh.interval.base":"100"},"log":{"slow.query.monitor.threshold":"-1"},"thread_pool":{"runtime.batch.executor":false},"runtime":{"runtime.retry.times":"3","runtime.retry.interval":"100","rpc.execute.timeout":"15000","rpc.operation.timeout":"10000","runtime.max.wait":"20000","connection.max.expired.time":"8"},"client_id":7409156147904779098} | +---------------------+--------------+-------------+--------------+----------+-----------+-----------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set ``` - [V$OB_KV_CLIENT_INFO](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000002015132) - [使用 OBKV-Table Java 客户端连接集群](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000002022344) 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线