--- title: "网络连接 - 数据库代理 V4.3.2 | OceanBase 文档中心" description: "网络连接 本文介绍如何查看 ODP 上所有网络连接的内部属性状态。 命令介绍 您可通过 SHOW PROXYNET CONNECTION 语句查看 ODP 上所有网络连接的内部属性状态。 SHOW PROXYNET CONNECTION [thread_id [LIMIT xx]] 参数说明： thread_id ：…" --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*nSAhQbrBXKwAAAAAAAAAAAAADiGDAQ/original) 数据库代理 V 4.3.2 # 网络连接 更新时间：2026-04-14 17:41:09 [编辑](https://github.com/oceanbase/oceanbase-proxy-doc/edit/V4.3.2/zh-CN/500.connection-management/450.net-session.md) 本文介绍如何查看 ODP 上所有网络连接的内部属性状态。 ## 命令介绍 您可通过 `SHOW PROXYNET CONNECTION` 语句查看 ODP 上所有网络连接的内部属性状态。 ```shell 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 时，展示全部行。 语句执行后输出如下： ```shell *************************** 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 上所有网络连接的内部属性状态 ```shell obclient> SHOW PROXYNET CONNECTION\G ``` 输出如下： ```shell *************************** 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 的网络连接的内部属性状态 ```shell obclient> SHOW PROXYNET CONNECTION 0\G ``` 输出如下： ```shell *************************** 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 的网络连接的内部属性状态，并返回从第二行开始的两行记录 ```shell obclient> SHOW PROXYNET CONNECTION 0 limit 2 offset 1\G ``` 输出如下： ```shell *************************** 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 ``` 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线