本文介绍了两种查看 ODP 上网络连接的方法。
通过
SHOW PROCESSLIST语句查询当前租户的会话数量及会话 ID。示例如下：
obclient> SHOW PROCESSLIST; +------------+--------+------+-----------------------+-----------+-------------+-------------------+-------------------+-------+-------+ | Id | Tenant | User | Host | db | trans_count | svr_session_count | state | tid | pid | +------------+--------+------+-----------------------+-----------+-------------+-------------------+-------------------+-------+-------+ | 2147549229 | sys | root | XXX.XXX.XXX.XXX:48292 | oceanbase | 97 | 1 | MCS_ACTIVE_READER | 14531 | 14531 | +------------+--------+------+-----------------------+-----------+-------------+-------------------+-------------------+-------+-------+ 1 row in set (0.01 sec)各字段含义如下表所示：
字段 字段 Id ODP 内部标记每个客户端会话（ Client Session ）的 id号，即cs idTenant 租户 User 用户 Host 用户 IP 和端口号 db 数据库 trans_count OBProxy 传输的事务数量 svr_session_count 会话数量 state 客户端会话状态，存在如下几个状态： - MCS_INIT（初始化）
- MCS_ACTIVE_READER（激活）
- MCS_KEEP_ALIVE（保活）
- MCS_HALF_CLOSE（半关闭）
- MCS_CLOSED（已关闭）
tid 线程 ID pid 进程 ID 通过
SHOW PROXYNET CONNECTION语句查看 ODP 上所有网络连接的内部属性状态。SQL 语句如下：
SHOW PROXYNET CONNECTION [thread_id [LIMIT xx]]参数说明：
不指定
thread_id时，展示 ODP 上所有网络连接的内部属性状态。指定
thread_id时，展示指定 thread 上的连接状态。支持指定LIMIT [offset,] rows和LIMIT rows OFFSET offset参数，格式与 MySQL 完全兼容。当rows == -1时，展示全部行。
示例如下：
obclient> SHOW PROXYNET CONNECTION\G *************************** 1. row *************************** thread_id: 0 connect_id: 1 socket_fd: 4 type: inner connected src_ip: XXX.XXX.XXX.XXX src_port: 43051 dst_ip: XXX.XXX.XXX.XXX dst_port: 13203 virtual_ip: *Not IP address [0]* virtual_port: 0 bind_style: any read_enabled: 1 read_nbytes: 9223372036854775807 read_ndone: 0 write_enabled: 0 write_nbyte: 0 write_ndone: 0 alive_time(sec): 2864 activity_timeout_in(sec): 0 inactivity_timeout_in(sec): 28800 timeout_close_in(sec): 28791 last_error_no: 0 shutdown: 0 comments: not closed *************************** 2. row *************************** thread_id: 0 connect_id: 3 socket_fd: 24 type: accepted src_ip: XXX.XXX.XXX.XXX src_port: 48292 dst_ip: XXX.XXX.XXX.XXX dst_port: 13205 virtual_ip: *Not IP address [0]* virtual_port: 0 bind_style: any read_enabled: 1 read_nbytes: 9223372036854775807 read_ndone: 0 write_enabled: 0 write_nbyte: 0 write_ndone: 0 alive_time(sec): 1214 activity_timeout_in(sec): 0 inactivity_timeout_in(sec): 30 timeout_close_in(sec): 29 last_error_no: 0 shutdown: 0 comments: not closed *************************** 3. row *************************** thread_id: 0 connect_id: 4 socket_fd: 28 type: connected src_ip: XXX.XXX.XXX.XXX src_port: 43154 dst_ip: XXX.XXX.XXX.XXX dst_port: 13203 virtual_ip: *Not IP address [0]* virtual_port: 0 bind_style: any read_enabled: 1 read_nbytes: 9223372036854775807 read_ndone: 0 write_enabled: 0 write_nbyte: 0 write_ndone: 0 alive_time(sec): 1214 activity_timeout_in(sec): 0 inactivity_timeout_in(sec): 28800 timeout_close_in(sec): 28788 last_error_no: 0 shutdown: 0 comments: not closed *************************** 4. row *************************** thread_id: 1 connect_id: 5 socket_fd: 29 type: inner connected src_ip: XXX.XXX.XXX.XXX src_port: 43156 dst_ip: XXX.XXX.XXX.XXX dst_port: 13203 virtual_ip: *Not IP address [0]* virtual_port: 0 bind_style: any read_enabled: 1 read_nbytes: 9223372036854775807 read_ndone: 0 write_enabled: 0 write_nbyte: 0 write_ndone: 0 alive_time(sec): 1194 activity_timeout_in(sec): 0 inactivity_timeout_in(sec): 28800 timeout_close_in(sec): 28791 last_error_no: 0 shutdown: 0 comments: not closed *************************** 5. row *************************** thread_id: 3 connect_id: 2 socket_fd: 25 type: inner connected src_ip: XXX.XXX.XXX.XXX src_port: 43052 dst_ip: XXX.XXX.XXX.XXX dst_port: 13203 virtual_ip: *Not IP address [0]* virtual_port: 0 bind_style: any read_enabled: 1 read_nbytes: 9223372036854775807 read_ndone: 0 write_enabled: 0 write_nbyte: 0 write_ndone: 0 alive_time(sec): 2853 activity_timeout_in(sec): 0 inactivity_timeout_in(sec): 28800 timeout_close_in(sec): 28799 last_error_no: 0 shutdown: 0 comments: not closed 5 rows in set (0.00 sec) obclient> SHOW PROXYNET CONNECTION 0\G *************************** 1. row *************************** thread_id: 0 connect_id: 1 socket_fd: 4 type: inner connected src_ip: XXX.XXX.XXX.XXX src_port: 43051 dst_ip: XXX.XXX.XXX.XXX dst_port: 13203 virtual_ip: *Not IP address [0]* virtual_port: 0 bind_style: any read_enabled: 1 read_nbytes: 9223372036854775807 read_ndone: 0 write_enabled: 0 write_nbyte: 11958 write_ndone: 11958 alive_time(sec): 2919 activity_timeout_in(sec): 0 inactivity_timeout_in(sec): 30 timeout_close_in(sec): 30 last_error_no: 0 shutdown: 0 comments: not closed *************************** 2. row *************************** thread_id: 0 connect_id: 3 socket_fd: 24 type: accepted src_ip: XXX.XXX.XXX.XXX src_port: 48292 dst_ip: XXX.XXX.XXX.XXX dst_port: 13205 virtual_ip: *Not IP address [0]* virtual_port: 0 bind_style: any read_enabled: 1 read_nbytes: 9223372036854775807 read_ndone: 0 write_enabled: 0 write_nbyte: 0 write_ndone: 0 alive_time(sec): 1269 activity_timeout_in(sec): 0 inactivity_timeout_in(sec): 30 timeout_close_in(sec): 29 last_error_no: 0 shutdown: 0 comments: not closed *************************** 3. row *************************** thread_id: 0 connect_id: 4 socket_fd: 28 type: connected src_ip: XXX.XXX.XXX.XXX src_port: 43154 dst_ip: XXX.XXX.XXX.XXX dst_port: 13203 virtual_ip: *Not IP address [0]* virtual_port: 0 bind_style: any read_enabled: 1 read_nbytes: 9223372036854775807 read_ndone: 0 write_enabled: 0 write_nbyte: 0 write_ndone: 0 alive_time(sec): 1269 activity_timeout_in(sec): 0 inactivity_timeout_in(sec): 28800 timeout_close_in(sec): 28733 last_error_no: 0 shutdown: 0 comments: not closed 3 rows in set (0.01 sec) obclient> SHOW PROXYNET CONNECTION 0 limit 2 offset 1\G *************************** 1. row *************************** thread_id: 0 connect_id: 3 socket_fd: 24 type: accepted src_ip: XXX.XXX.XXX.XXX src_port: 48292 dst_ip: XXX.XXX.XXX.XXX dst_port: 13205 virtual_ip: *Not IP address [0]* virtual_port: 0 bind_style: any read_enabled: 1 read_nbytes: 9223372036854775807 read_ndone: 0 write_enabled: 0 write_nbyte: 0 write_ndone: 0 alive_time(sec): 1299 activity_timeout_in(sec): 0 inactivity_timeout_in(sec): 30 timeout_close_in(sec): 29 last_error_no: 0 shutdown: 0 comments: not closed *************************** 2. row *************************** thread_id: 0 connect_id: 4 socket_fd: 28 type: connected src_ip: XXX.XXX.XXX.XXX src_port: 43154 dst_ip: XXX.XXX.XXX.XXX dst_port: 13203 virtual_ip: *Not IP address [0]* virtual_port: 0 bind_style: any read_enabled: 1 read_nbytes: 9223372036854775807 read_ndone: 0 write_enabled: 0 write_nbyte: 0 write_ndone: 0 alive_time(sec): 1299 activity_timeout_in(sec): 0 inactivity_timeout_in(sec): 28800 timeout_close_in(sec): 28703 last_error_no: 0 shutdown: 0 comments: not closed 2 rows in set (0.00 sec)各字段含义如下表所示：
字段 字段 thread_id 线程 ID connect_id 网络连接 ID socket_fd 套接字描述符 type 连接状态 src_ip 源 IP src_port 源端口 dst_ip 目的 IP dst_port 目的端口 virtual_ip 虚拟 IP virtual_port 虚拟端口 bind_style 绑定类型 read_enabled 是否可读 read_nbytes 需要读取的数据字节数 read_ndone 已经读取的数据字节数 write_enabled 是否可写 write_nbyte 需要发送的数据字节数 write_ndone 已经发送的数据字节数 alive_time(sec) 存活时间 activity_timeout_in(sec) 活跃超时 inactivity_timeout_in(sec) 不活跃超时时长 timeout_close_in(sec) 超时关闭时长 last_error_no 最近出错的错误号 shutdown 已断开的网络连接 comments 注释
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
