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