首批通过分布式安全可靠测评，为关键业务系统打造
网络连接
更新时间：2026-04-14 17:41:11
编辑
分享
本文介绍如何查看 ODP 上所有网络连接的内部属性状态。
命令介绍
您可通过 SHOW PROXYNET CONNECTION 语句查看 ODP 上所有网络连接的内部属性状态。
SHOW PROXYNET CONNECTION [thread_id [LIMIT xx]]
参数说明：
thread_id：线程 ID，不指定 thread_id 时，展示 ODP 上所有网络连接的内部属性状态；指定 thread_id 时，仅展示指定 thread 上的连接状态。LIMIT xx：支持指定 LIMIT [offset,] rows 和 LIMIT rows OFFSET offset 参数，格式与 MySQL 完全兼容。当 rows == -1 时，展示全部行。
语句执行后输出如下：
*************************** 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
各字段含义可见下表。
| 字段 | 含义 |
|---|---|
| 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 | 注释 |
示例
SHOW PROXYNET CONNECTION 语句的使用方法如下所示。
查看 ODP 上所有网络连接的内部属性状态
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查看 ODP 上线程 ID 为 0 的网络连接的内部属性状态
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查看 ODP 上线程 ID 为 0 的网络连接的内部属性状态，并返回从第二行开始的两行记录
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): 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 *************************** 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): 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 2 rows in set
