描述

    使用show proxynet connection [thread_id [LIMIT xx]]语句：

    • 展示proxy当前各个连接内部属性状态；也可展示指定thread上的各连接状态，支持limit。
    • 默认不指定thread id时展示proxy内部全部connection内部属性状态，指定thread id时展示指定thread上connection。
    • 在指定thread id时，支持LIMIT [offset,] rows 和 LIMIT rows OFFSET offset，格式与mysql完全兼容，并且当rows == -1时，展示全部行。

    示例

    1. OceanBase (root@oceanbase)> show processlist;
    2. +------------+--------+------+--------------------+-----------+-------------+-------------------+-------------------+-------+-------+
    3. | Id         | Tenant | User | Host               | db        | trans_count | svr_session_count | state             | tid   | pid   |
    4. +------------+--------+------+--------------------+-----------+-------------+-------------------+-------------------+-------+-------+
    5. | 2147549229 | sys    | root | 10.125.111.4:48292 | oceanbase |          97 |                 1 | MCS_ACTIVE_READER | 14531 | 14531 |
    6. +------------+--------+------+--------------------+-----------+-------------+-------------------+-------------------+-------+-------+
    7. 1 row in set (0.01 sec)
    9. OceanBase (root@oceanbase)> show proxynet connection\G
    10. *************************** 1. row ***************************
    11.                  thread_id: 0
    12.                 connect_id: 1
    13.                  socket_fd: 4
    14.                       type: inner connected
    15.                     src_ip: 10.125.111.18
    16.                   src_port: 43051
    17.                     dst_ip: 10.111.4.27
    18.                   dst_port: 13203
    19.                 virtual_ip: *Not IP address [0]*
    20.               virtual_port: 0
    21.                 bind_style: any
    22.               read_enabled: 1
    23.                read_nbytes: 9223372036854775807
    24.                 read_ndone: 0
    25.              write_enabled: 0
    26.                write_nbyte: 0
    27.                write_ndone: 0
    28.            alive_time(sec): 2864
    29.   activity_timeout_in(sec): 0
    30. inactivity_timeout_in(sec): 28800
    31.      timeout_close_in(sec): 28791
    32.              last_error_no: 0
    33.                   shutdown: 0
    34.                   comments: not closed
    35. *************************** 2. row ***************************
    36.                  thread_id: 0
    37.                 connect_id: 3
    38.                  socket_fd: 24
    39.                       type: accepted
    40.                     src_ip: 10.125.111.4
    41.                   src_port: 48292
    42.                     dst_ip: 10.125.111.18
    43.                   dst_port: 13205
    44.                 virtual_ip: *Not IP address [0]*
    45.               virtual_port: 0
    46.                 bind_style: any
    47.               read_enabled: 1
    48.                read_nbytes: 9223372036854775807
    49.                 read_ndone: 0
    50.              write_enabled: 0
    51.                write_nbyte: 0
    52.                write_ndone: 0
    53.            alive_time(sec): 1214
    54.   activity_timeout_in(sec): 0
    55. inactivity_timeout_in(sec): 30
    56.      timeout_close_in(sec): 29
    57.              last_error_no: 0
    58.                   shutdown: 0
    59.                   comments: not closed
    60. *************************** 3. row ***************************
    61.                  thread_id: 0
    62.                 connect_id: 4
    63.                  socket_fd: 28
    64.                       type: connected
    65.                     src_ip: 10.125.111.18
    66.                   src_port: 43154
    67.                     dst_ip: 10.111.4.27
    68.                   dst_port: 13203
    69.                 virtual_ip: *Not IP address [0]*
    70.               virtual_port: 0
    71.                 bind_style: any
    72.               read_enabled: 1
    73.                read_nbytes: 9223372036854775807
    74.                 read_ndone: 0
    75.              write_enabled: 0
    76.                write_nbyte: 0
    77.                write_ndone: 0
    78.            alive_time(sec): 1214
    79.   activity_timeout_in(sec): 0
    80. inactivity_timeout_in(sec): 28800
    81.      timeout_close_in(sec): 28788
    82.              last_error_no: 0
    83.                   shutdown: 0
    84.                   comments: not closed
    85. *************************** 4. row ***************************
    86.                  thread_id: 1
    87.                 connect_id: 5
    88.                  socket_fd: 29
    89.                       type: inner connected
    90.                     src_ip: 10.125.111.18
    91.                   src_port: 43156
    92.                     dst_ip: 10.111.4.27
    93.                   dst_port: 13203
    94.                 virtual_ip: *Not IP address [0]*
    95.               virtual_port: 0
    96.                 bind_style: any
    97.               read_enabled: 1
    98.                read_nbytes: 9223372036854775807
    99.                 read_ndone: 0
    100.              write_enabled: 0
    101.                write_nbyte: 0
    102.                write_ndone: 0
    103.            alive_time(sec): 1194
    104.   activity_timeout_in(sec): 0
    105. inactivity_timeout_in(sec): 28800
    106.      timeout_close_in(sec): 28791
    107.              last_error_no: 0
    108.                   shutdown: 0
    109.                   comments: not closed
    110. *************************** 5. row ***************************
    111.                  thread_id: 3
    112.                 connect_id: 2
    113.                  socket_fd: 25
    114.                       type: inner connected
    115.                     src_ip: 10.125.111.18
    116.                   src_port: 43052
    117.                     dst_ip: 10.111.4.27
    118.                   dst_port: 13203
    119.                 virtual_ip: *Not IP address [0]*
    120.               virtual_port: 0
    121.                 bind_style: any
    122.               read_enabled: 1
    123.                read_nbytes: 9223372036854775807
    124.                 read_ndone: 0
    125.              write_enabled: 0
    126.                write_nbyte: 0
    127.                write_ndone: 0
    128.            alive_time(sec): 2853
    129.   activity_timeout_in(sec): 0
    130. inactivity_timeout_in(sec): 28800
    131.      timeout_close_in(sec): 28799
    132.              last_error_no: 0
    133.                   shutdown: 0
    134.                   comments: not closed
    135. 5 rows in set (0.00 sec)
    137. OceanBase (root@oceanbase)> show proxynet connection 2\G
    138. Empty set (0.00 sec)
    140. OceanBase (root@oceanbase)> show proxynet connection 0\G
    141. *************************** 1. row ***************************
    142.                  thread_id: 0
    143.                 connect_id: 1
    144.                  socket_fd: 4
    145.                       type: inner connected
    146.                     src_ip: 10.125.111.18
    147.                   src_port: 43051
    148.                     dst_ip: 10.111.4.27
    149.                   dst_port: 13203
    150.                 virtual_ip: *Not IP address [0]*
    151.               virtual_port: 0
    152.                 bind_style: any
    153.               read_enabled: 1
    154.                read_nbytes: 9223372036854775807
    155.                 read_ndone: 0
    156.              write_enabled: 0
    157.                write_nbyte: 11958
    158.                write_ndone: 11958
    159.            alive_time(sec): 2919
    160.   activity_timeout_in(sec): 0
    161. inactivity_timeout_in(sec): 30
    162.      timeout_close_in(sec): 30
    163.              last_error_no: 0
    164.                   shutdown: 0
    165.                   comments: not closed
    166. *************************** 2. row ***************************
    167.                  thread_id: 0
    168.                 connect_id: 3
    169.                  socket_fd: 24
    170.                       type: accepted
    171.                     src_ip: 10.125.111.4
    172.                   src_port: 48292
    173.                     dst_ip: 10.125.111.18
    174.                   dst_port: 13205
    175.                 virtual_ip: *Not IP address [0]*
    176.               virtual_port: 0
    177.                 bind_style: any
    178.               read_enabled: 1
    179.                read_nbytes: 9223372036854775807
    180.                 read_ndone: 0
    181.              write_enabled: 0
    182.                write_nbyte: 0
    183.                write_ndone: 0
    184.            alive_time(sec): 1269
    185.   activity_timeout_in(sec): 0
    186. inactivity_timeout_in(sec): 30
    187.      timeout_close_in(sec): 29
    188.              last_error_no: 0
    189.                   shutdown: 0
    190.                   comments: not closed
    191. *************************** 3. row ***************************
    192.                  thread_id: 0
    193.                 connect_id: 4
    194.                  socket_fd: 28
    195.                       type: connected
    196.                     src_ip: 10.125.111.18
    197.                   src_port: 43154
    198.                     dst_ip: 10.111.4.27
    199.                   dst_port: 13203
    200.                 virtual_ip: *Not IP address [0]*
    201.               virtual_port: 0
    202.                 bind_style: any
    203.               read_enabled: 1
    204.                read_nbytes: 9223372036854775807
    205.                 read_ndone: 0
    206.              write_enabled: 0
    207.                write_nbyte: 0
    208.                write_ndone: 0
    209.            alive_time(sec): 1269
    210.   activity_timeout_in(sec): 0
    211. inactivity_timeout_in(sec): 28800
    212.      timeout_close_in(sec): 28733
    213.              last_error_no: 0
    214.                   shutdown: 0
    215.                   comments: not closed
    216. 3 rows in set (0.01 sec)
    218. OceanBase (root@oceanbase)> show proxynet connection 0  limit 2 offset 1\G
    219. *************************** 1. row ***************************
    220.                  thread_id: 0
    221.                 connect_id: 3
    222.                  socket_fd: 24
    223.                       type: accepted
    224.                     src_ip: 10.125.111.4
    225.                   src_port: 48292
    226.                     dst_ip: 10.125.111.18
    227.                   dst_port: 13205
    228.                 virtual_ip: *Not IP address [0]*
    229.               virtual_port: 0
    230.                 bind_style: any
    231.               read_enabled: 1
    232.                read_nbytes: 9223372036854775807
    233.                 read_ndone: 0
    234.              write_enabled: 0
    235.                write_nbyte: 0
    236.                write_ndone: 0
    237.            alive_time(sec): 1299
    238.   activity_timeout_in(sec): 0
    239. inactivity_timeout_in(sec): 30
    240.      timeout_close_in(sec): 29
    241.              last_error_no: 0
    242.                   shutdown: 0
    243.                   comments: not closed
    244. *************************** 2. row ***************************
    245.                  thread_id: 0
    246.                 connect_id: 4
    247.                  socket_fd: 28
    248.                       type: connected
    249.                     src_ip: 10.125.111.18
    250.                   src_port: 43154
    251.                     dst_ip: 10.111.4.27
    252.                   dst_port: 13203
    253.                 virtual_ip: *Not IP address [0]*
    254.               virtual_port: 0
    255.                 bind_style: any
    256.               read_enabled: 1
    257.                read_nbytes: 9223372036854775807
    258.                 read_ndone: 0
    259.              write_enabled: 0
    260.                write_nbyte: 0
    261.                write_ndone: 0
    262.            alive_time(sec): 1299
    263.   activity_timeout_in(sec): 0
    264. inactivity_timeout_in(sec): 28800
    265.      timeout_close_in(sec): 28703
    266.              last_error_no: 0
    267.                   shutdown: 0
    268.                   comments: not closed
    269. 2 rows in set (0.00 sec)