展示 Session 详细状态

本文介绍了查看 ODP 指定 Client Session 的详细内部状态的方法。

通过 SHOW PROXYSESSION ATTRIBUTE 语句可以查看指定 Client Session 的详细内部状态，包括该 Client Session 上涉及的相关 Server Session。SQL 语句如下：

SHOW PROXYSESSION ATTRIBUTE [id [like 'xxx']]

参数说明：

• 不指定 id 时，显示当前 Session 的详细状态( ODP 1.1.0 版本起开始支持)，支持模糊查询当前 Session 指定属性名称的 value ( proxy 1.1.2 版本起开始支持)。

• 指定 id 时， 支持模糊查询指定属性名称的 value ( ODP 1.1.0 版本起开始支持)。

• id 既可以是 cs_id，也可以是 CONNECTION_ID，显示结果相同。

• cs_id 为 ODP 内部标记的每个 Client 的 id 号，CONNECTION_ID 为整个 OceanBase 数据库标记的每个 Client 的 id 号。有关 CONNECTION_ID 的详细介绍，请参见 CONNECTION_ID。

• like 模糊匹配，支持 '%' 和 '_' 。

通过 SHOW PROXYSESSION ATTRIBUTE 语句查看指定 Client Session 的详细内部状态。示例如下：

obclient> SHOW PROXYSESSION;
+--------------------+------+-----------------+--------+------+-----------------+------+-------------+-------------------+-------------------+---------+---------+
| proxy_sessid       | Id   | Cluster         | Tenant | User | Host            | db   | trans_count | svr_session_count | state             | tid     | pid     |
+--------------------+------+-----------------+--------+------+-----------------+------+-------------+-------------------+-------------------+---------+---------+
| 756006681247547396 |    2 | ob1.jihua.sjh | sys    | root | 127.0.0.1:22540 | NULL |           0 |                 1 | MCS_ACTIVE_READER | 2230520 | 2230520 |
+--------------------+------+-----------------+--------+------+-----------------+------+-------------+-------------------+-------------------+---------+---------+
1 row in set

obclient> SHOW PROXYSESSION ATTRIBUTE;
+------------------------+---------------------+----------------+
| attribute_name         | value               | info           |
+------------------------+---------------------+----------------+
| proxy_sessid           | 756006681247547396  | cs common      |
| cs_id                  | 2                   | cs common      |
| cluster                | ob1.jianhua.sjh     | cs common      |
| tenant                 | sys                 | cs common      |
| user                   | root                | cs common      |
| host_ip                | 127.0.0.1           | cs common      |
| host_port              | 22540               | cs common      |
| db                     | NULL                | cs common      |
| total_trans_cnt        | 0                   | cs common      |
| svr_session_cnt        | 1                   | cs common      |
| active                 | true                | cs common      |
| read_state             | MCS_ACTIVE_READER   | cs common      |
| tid                    | 2230520             | cs common      |
| pid                    | 2230520             | cs common      |
| modified_time          | 1469435190244371115 | cs stat        |
| reported_time          | 1469435190244371115 | cs stat        |
| hot_sys_var_version    | 0                   | cs var version |
| sys_var_version        | 0                   | cs var version |
| user_var_version       | 0                   | cs var version |
| last_insert_id_version | 0                   | cs var version |
| db_name_version        | 0                   | cs var version |
| server_ip              | xx.xx.xx.xx         | last used ss   |
| server_port            | 13203               | last used ss   |
| server_sessid          | 2147549201          | last used ss   |
| ss_id                  | 4                   | last used ss   |
| state                  | MSS_KA_CLIENT_SLAVE | last used ss   |
| transact_count         | 2                   | last used ss   |
| server_trans_stat      | 0                   | last used ss   |
| hot_sys_var_version    | 0                   | last used ss   |
| sys_var_version        | 0                   | last used ss   |
| user_var_version       | 0                   | last used ss   |
| last_insert_id_version | 0                   | last used ss   |
| db_name_version        | 0                   | last used ss   |
+------------------------+---------------------+----------------+
33 rows in set

obclient> SHOW PROXYSESSION ATTRIBUTE 2 like '%id%';
+------------------------+--------------------+----------------+
| attribute_name         | value              | info           |
+------------------------+--------------------+----------------+
| proxy_sessid           | 756006681247547396 | cs common      |
| cs_id                  | 2                  | cs common      |
| tid                    | 2230520            | cs common      |
| pid                    | 2230520            | cs common      |
| last_insert_id_version | 0                  | cs var version |
| server_sessid          | 2147549201         | last used ss   |
| ss_id                  | 4                  | last used ss   |
| last_insert_id_version | 0                  | last used ss   |
+------------------------+--------------------+----------------+
8 rows in set

obclient> SHOW PROXYSESSION ATTRIBUTE 2147549201 like '%id%';
+------------------------+--------------------+----------------+
| attribute_name         | value              | info           |
+------------------------+--------------------+----------------+
| proxy_sessid           | 756006681247547396 | cs common      |
| cs_id                  | 2                  | cs common      |
| tid                    | 2230520            | cs common      |
| pid                    | 2230520            | cs common      |
| last_insert_id_version | 0                  | cs var version |
| server_sessid          | 2147549201         | last used ss   |
| ss_id                  | 4                  | last used ss   |
| last_insert_id_version | 0                  | last used ss   |
+------------------------+--------------------+----------------+
8 rows in set

各字段含义如下表所示：

常见的属性及其说明如下表所示：