V$OB_KV_CLIENT_INFO

最終更新:2026-09-04 09:48:49

Note

This view was introduced in OceanBase Database V4.2.5. It applies to the OBKV-Table client.

Purpose

The V$OB_KV_CLIENT_INFO view displays the parameters of client connections in the current OBKV tenant on the current OBServer node. You can query this view from a MySQL tenant.

Columns

Column	Type	Nullable?	Description
client_id	bigint	NO	The ID of the client.
client_ip	varchar:MAX_IP_ADDR_LENGTH	NO	The IP address of the client.
client_port	bigint	NO	The port number of the client.
svr_ip	varchar:MAX_IP_ADDR_LENGTH	NO	The IP address of the OBServer node.
svr_port	bigint	NO	The port number of the OBServer node.
tenant_id	bigint	NO	The ID of the tenant.
user_name	varchar::OB_MAX_USER_NAME_LENGTH	NO	The username.
first_login_ts	timestamp(6)	NO	The time of the first login.
last_login_ts	timestamp(6)	NO	The time of the last login.
client_info	varchar:2048	NO	The client information in the JSON format.

Here is an example of client_info:

{  
  "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"
  }
}

The following table describes the parameters in the preceding client information.

Parameter	Default value	Description
metadata.refresh.interval	60000	The time interval of metadata refresh.
rpc.execute.timeout	3000	The socket timeout period for executing the remote procedure call (RPC) request.
rpc.operation.timeout	10000	The timeout period for executing an internal RPC request in OceanBase Database.
runtime.continuous.failure.ceiling	100	The threshold of consecutive runtime failures before the refresh of the table address.
runtime.max.wait	3000	The timeout period for the execution of a single request. The request execution is retried within the timeout period.
runtime.retry.interval	1	The time interval between two consecutive retries when a runtime error occurs.
runtime.retry.times	1	The number of retries when an error that allows retries occurs during the runtime.
server.address.caching.timeout	3600000L	The period before the server address cache expires.
server.address.priority.timeout	1800000L	The period before the server address priority expires.
slow.query.monitor.threshold	10	The running duration threshold that triggers the recording of slow operations to monitoring logs.
table.entry.acquire.connect.timeout	500	The timeout period after which the table address is refreshed and a request to create a connection is initiated.
table.entry.acquire.socket.timeout	3000	The socket timeout period after which the table address is refreshed.
table.entry.refresh.interval.base	100	The basic time interval for refreshing the table address.
table.entry.refresh.interval.ceiling	1600	The maximum time interval for refreshing the table address.
table.entry.refresh.try.times	3	The number of attempts allowed to refresh the table address.
runtime.batch.executor	false	The resource pool for concurrent execution of batch requests.
connection.max.expired.time	8s	The maximum time interval for refreshing the client connection for a re-login.

次のトピック

What's New