V$OB_KV_CLIENT_INFO

更新时间：2026-07-13 22:33:26

说明

该视图从 V4.3.4 版本开始引入，主要适用于 OBKV-Table 客户端。

功能描述

在 MySQL 租户下，视图 V$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 字符串格式如下：

{
  "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	8s	客户端连接刷新重新登录的最大时间间隔

查询示例

在 MySQL 租户中查询视图 V$OB_KV_CLIENT_INFO 的语句为：

obclient [mysql]> SELECT * FROM oceanbase.V$OB_KV_CLIENT_INFO LIMIT 1;

返回结果示例如下：

+---------------------+--------------+-------------+--------------+----------+-----------+-----------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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