描述

    使用show proxycongestion [all] [clustername]语句：

    • show proxycongestion : 展示所有cluster的黑名单信息。黑名单指 : dead_congested, alive_congested, is_zone_upgrading, is_zone_merging, is_server_upgrading任意一个状态为true。
    • show proxycongestion all : 展示所有cluster的server信息（包括黑名单中和非黑名单中的server信息）。
    • show proxycongestion clustername : 展示指定cluster的黑名单信息。
    • show proxycongestion all clustername : 展示指定cluster的server信息。
    • proxy 1.1.2版本之前， clustername不需要单引号或者双引号引起来， 1.1.2版本及之后，必须要用单引号或者双引号引起来。

    示例

    1. OceanBase (root@oceanbase)> show proxycongestion;
    2. *************************** 1. row ***************************
    3.         cluster_name: ob1.jianhua.sjh
    4.            zone_name: zone1
    5.           zone_state: ACTIVE
    6.            server_ip: 10.111.4.28:13201
    7.         server_state: ACTIVE
    8.      alive_congested: 0
    9. last_alive_congested: 0
    10.       dead_congested: 0
    11.  last_dead_congested: 0
    12.  stat_alive_failures: 0
    13.   stat_conn_failures: 0
    14.  conn_last_fail_time: 0
    15.  conn_failure_events: 0
    16. alive_last_fail_time: 0
    17. alive_failure_events: 0
    18.            ref_count: 1
    19. *************************** 2. row ***************************
    20.         cluster_name: ob1.jianhua.sjh
    21.            zone_name: zone1
    22.           zone_state: ACTIVE
    23.            server_ip: 10.111.4.27:13203
    24.         server_state: ACTIVE
    25.      alive_congested: 0
    26. last_alive_congested: 0
    27.       dead_congested: 0
    28.  last_dead_congested: 0
    29.  stat_alive_failures: 0
    30.   stat_conn_failures: 0
    31.  conn_last_fail_time: 0
    32.  conn_failure_events: 0
    33. alive_last_fail_time: 0
    34. alive_failure_events: 0
    35.            ref_count: 1
    36. 2 rows in set (0.00 sec)
    38. OceanBase (root@oceanbase)> show proxycongestion all\G
    39. *************************** 1. row ***************************
    40.         cluster_name: MetaDataBase
    41.            zone_name: zone1
    42.           zone_state: ACTIVE
    43.            server_ip: 10.111.4.28:13201
    44.         server_state: ACTIVE
    45.      alive_congested: 0
    46. last_alive_congested: 0
    47.       dead_congested: 0
    48.  last_dead_congested: 0
    49.  stat_alive_failures: 0
    50.   stat_conn_failures: 0
    51.  conn_last_fail_time: 0
    52.  conn_failure_events: 0
    53. alive_last_fail_time: 0
    54. alive_failure_events: 0
    55.            ref_count: 1
    56. *************************** 2. row ***************************
    57.         cluster_name: MetaDataBase
    58.            zone_name: zone1
    59.           zone_state: ACTIVE
    60.            server_ip: 10.111.4.27:13203
    61.         server_state: ACTIVE
    62.      alive_congested: 0
    63. last_alive_congested: 0
    64.       dead_congested: 0
    65.  last_dead_congested: 0
    66.  stat_alive_failures: 0
    67.   stat_conn_failures: 0
    68.  conn_last_fail_time: 0
    69.  conn_failure_events: 0
    70. alive_last_fail_time: 0
    71. alive_failure_events: 0
    72.            ref_count: 1
    73. *************************** 3. row ***************************
    74.         cluster_name: ob1.jianhua.sjh
    75.            zone_name: zone1
    76.           zone_state: ACTIVE
    77.            server_ip: 10.111.4.28:13201
    78.         server_state: ACTIVE
    79.      alive_congested: 0
    80. last_alive_congested: 0
    81.       dead_congested: 0
    82.  last_dead_congested: 0
    83.  stat_alive_failures: 0
    84.   stat_conn_failures: 0
    85.  conn_last_fail_time: 0
    86.  conn_failure_events: 0
    87. alive_last_fail_time: 0
    88. alive_failure_events: 0
    89.            ref_count: 1
    90. *************************** 4. row ***************************
    91.         cluster_name: ob1.jianhua.sjh
    92.            zone_name: zone1
    93.           zone_state: ACTIVE
    94.            server_ip: 10.111.4.27:13203
    95.         server_state: ACTIVE
    96.      alive_congested: 0
    97. last_alive_congested: 0
    98.       dead_congested: 0
    99.  last_dead_congested: 0
    100.  stat_alive_failures: 0
    101.   stat_conn_failures: 0
    102.  conn_last_fail_time: 0
    103.  conn_failure_events: 0
    104. alive_last_fail_time: 0
    105. alive_failure_events: 0
    106.            ref_count: 1
    107. 4 rows in set (0.01 sec)
    109. OceanBase (root@oceanbase)> show proxycongestion all ob1.jianhua.sjh\G
    110. *************************** 1. row ***************************
    111.         cluster_name: ob1.jianhua.sjh
    112.            zone_name: zone1
    113.           zone_state: ACTIVE
    114.            server_ip: 10.111.4.28:13201
    115.         server_state: ACTIVE
    116.      alive_congested: 0
    117. last_alive_congested: 0
    118.       dead_congested: 0
    119.  last_dead_congested: 0
    120.  stat_alive_failures: 0
    121.   stat_conn_failures: 0
    122.  conn_last_fail_time: 0
    123.  conn_failure_events: 0
    124. alive_last_fail_time: 0
    125. alive_failure_events: 0
    126.            ref_count: 1
    127. *************************** 2. row ***************************
    128.         cluster_name: ob1.jianhua.sjh
    129.            zone_name: zone1
    130.           zone_state: ACTIVE
    131.            server_ip: 10.111.4.27:13203
    132.         server_state: ACTIVE
    133.      alive_congested: 0
    134. last_alive_congested: 0
    135.       dead_congested: 0
    136.  last_dead_congested: 0
    137.  stat_alive_failures: 0
    138.   stat_conn_failures: 0
    139.  conn_last_fail_time: 0
    140.  conn_failure_events: 0
    141. alive_last_fail_time: 0
    142. alive_failure_events: 0
    143.            ref_count: 1
    144. 2 rows in set (0.00 sec)
    146. OceanBase (root@oceanbase)> show proxycongestion all ob1.jianhua\G
    147. ERROR 4018 (HY000): Entry not exist
    1. mysql> show proxyinfo binary\G
    2. *************************** 1. row ***************************
    3. name: binary info
    4. info: ObProxy-OceanBase 1.1.2-459.el6
    5. version:RELEASE_6U
    6. MD5:
    7. REVISION:459-local-5ba2e3d33ea201fb675eb704627162a584485cdd
    8. BUILD_TIME:Sep 29 2016 11:50:15
    9. BUILD_FLAGS:-D__STDC_LIMIT_MACROS -D_OB_VERSION=1000 -D__STDC_CONSTANT_MACROS -D_NO_EXCEPTION -g -Wall -Werror -Wextra -Wunused-parameter -Wformat -Wconversion -Wno-invalid-offsetof -Wno-deprecated -fno-strict-aliasing -fno-omit-frame-pointer -mtune=generic -Wno-psabi -Wno-sign-compare -DGCC_52 -DUSE_POSIX_FALLOCATE -DSUPPORT_SSE4_2 -DHAVE_SCHED_GETCPU -DHAVE_REALTIME_COARSE -DOB_HAVE_EVENTFD -DHAVE_FALLOCATE -DHAVE_MINIDUMP
    10. 1 row in set (0.00 sec)
    12. mysql> show proxycongestion all ob1.jianhua.sjh;
    13. ERROR 5010 (21000): Unknown operator
    14. mysql> show proxycongestion all "ob1.jianhua.sjh";
    15. +-----------------+-----------+------------+--------------------+--------------+-----------------+----------------------+----------------+---------------------+---------------------+--------------------+---------------------+---------------------+----------------------+----------------------+-----------+
    16. | cluster_name    | zone_name | zone_state | server_ip          | server_state | alive_congested | last_alive_congested | dead_congested | last_dead_congested | stat_alive_failures | stat_conn_failures | conn_last_fail_time | conn_failure_events | alive_last_fail_time | alive_failure_events | ref_count |
    17. +-----------------+-----------+------------+--------------------+--------------+-----------------+----------------------+----------------+---------------------+---------------------+--------------------+---------------------+---------------------+----------------------+----------------------+-----------+
    18. | ob1.jianhua.sjh | zone1     | ACTIVE     | 10.125.111.7:13201 | ACTIVE       |               0 | 0                    |              0 | 0                   |                   0 |                  0 | 0                   |                   0 | 0                    |                    0 |         2 |
    19. +-----------------+-----------+------------+--------------------+--------------+-----------------+----------------------+----------------+---------------------+---------------------+--------------------+---------------------+---------------------+----------------------+----------------------+-----------+
    20. 1 row in set (0.00 sec)