【手摸手玩转 OceanBase 47】查看 ODP 上指定 Client Session 的 Session 变量的方法
本文介绍了查看 ODP 上指定 Client Session 的 Session 变量的方法。
Session 变量分为系统变量和用户变量。
通过
SHOW PROXYSESSION VARIABLES [all] id [like 'xx'] 语句可以查看指定 Client Session 的 Session 变量。
-
不带
all参数时，展示指定 Client Session 的本地 Session 变量 (包括：修改过的系统变量和用户变量)。 -
带
all参数时，展示指定 Client Session 的全部 Session 变量 (包括：所有系统变量和用户变量)。
参数说明：
-
id既可以是cs_id，也可以是connection_id，显示结果相同。 -
cs_id为 ODP 内部标记的每个 client 的id号，connection_id为整个 OceanBase 数据库标记的每个 client 的id号。有关CONNECTION_ID的详细介绍，请参见 CONNECTION_ID。 -
like 模糊匹配，支持 '%' 和 '_' 。
通过
SHOW PROXYSESSION VARIABLES 语句查看指定 Client Session 的 Session 变量。示例如下：
obclient> SHOW PROXYSESSION VARIABLES 3; +-----------------------------------+------------------+-----------------+--------------------+--------------------------------------------+ | variable_name | value | info | modified_type | sys_variable_flag | +-----------------------------------+------------------+-----------------+--------------------+--------------------------------------------+ | ob_proxy_global_variables_version | 1461742173142100 | changed sys var | cold modified vars | && invisible && session_scope && readonly | | ob_proxy_user_privilege | 65534 | changed sys var | cold modified vars | && invisible && session_scope && readonly | +-----------------------------------+------------------+-----------------+--------------------+--------------------------------------------+ 2 rows in set obclient> SHOW PROXYSESSION VARIABLES 2147549231; +-----------------------------------+------------------+-----------------+--------------------+--------------------------------------------+ | variable_name | value | info | modified_type | sys_variable_flag | +-----------------------------------+------------------+-----------------+--------------------+--------------------------------------------+ | ob_proxy_global_variables_version | 1461742173142100 | changed sys var | cold modified vars | && invisible && session_scope && readonly | | ob_proxy_user_privilege | 65534 | changed sys var | cold modified vars | && invisible && session_scope && readonly | +-----------------------------------+------------------+-----------------+--------------------+--------------------------------------------+ 2 rows in set obclient> SHOW PROXYSESSION VARIABLES all 3; +-----------------------------------+------------------------------------------------------------------------------------------------------+---------+------------------------------+-----------------------------------------------+ | variable_name | value | info | modified_type | sys_variable_flag | +-----------------------------------+------------------------------------------------------------------------------------------------------+---------+------------------------------+-----------------------------------------------+ | ob_proxy_global_variables_version | 1461742173142100 | sys var | cold modified vars | && invisible && session_scope && readonly | | ob_proxy_user_privilege | 65534 | sys var | cold modified vars | && invisible && session_scope && readonly | | autocommit | 1 | sys var | hot modified vars | && global_scope && session_scope | | auto_increment_increment | 1 | sys var | cold modified vars | && global_scope && session_scope | | auto_increment_offset | 1 | sys var | cold modified vars | && global_scope && session_scope | | binlog_row_image | 2 | sys var | cold modified vars | && global_scope && session_scope | | character_set_client | 45 | sys var | cold modified vars | && global_scope && session_scope && nullable | | character_set_connection | 45 | sys var | cold modified vars | && global_scope && session_scope && nullable | | character_set_database | 45 | sys var | cold modified vars | && global_scope && session_scope && nullable | | character_set_filesystem | 63 | sys var | cold modified vars | && global_scope && session_scope && nullable | | character_set_results | 45 | sys var | cold modified vars | && global_scope && session_scope && nullable | | character_set_server | 45 | sys var | cold modified vars | && global_scope && session_scope && nullable | | character_set_system | 45 | sys var | cold modified vars | && global_scope && session_scope && readonly | | collation_connection | 45 | sys var | cold modified vars | && global_scope && session_scope && nullable | | collation_database | 45 | sys var | cold modified vars | && global_scope && session_scope && nullable | | collation_server | 45 | sys var | cold modified vars | && global_scope && session_scope && nullable | | connect_timeout | 10 | sys var | cold modified vars | && global_scope | | datadir | /usr/local/mysql/data/ | sys var | cold modified vars | && global_scope && readonly | | debug_sync | | sys var | cold modified vars | && invisible && session_scope | | div_precision_increment | 4 | sys var | cold modified vars | && global_scope && session_scope | | explicit_defaults_for_timestamp | 1 | sys var | cold modified vars | && global_scope && session_scope | | group_concat_max_len | 1024 | sys var | cold modified vars | && global_scope && session_scope | | identity | 0 | sys var | cold modified vars | && session_scope | | init_connect | | sys var | cold modified vars | && global_scope | | interactive_timeout | 28800 | sys var | cold modified vars | && global_scope && session_scope | | last_insert_id | 0 | sys var | last insert id modified vars | && session_scope | | license | | sys var | cold modified vars | && global_scope && readonly | | lower_case_table_names | 2 | sys var | cold modified vars | && global_scope && readonly | | max_allowed_packet | 4194304 | sys var | cold modified vars | && global_scope && session_scope && readonly | | max_user_connections | 0 | sys var | cold modified vars | && global_scope && session_scope && readonly | | net_read_timeout | 30 | sys var | cold modified vars | && global_scope && session_scope | | net_write_timeout | 60 | sys var | cold modified vars | && global_scope && session_scope | | ob_bnl_join_cache_size | 10485760 | sys var | cold modified vars | && global_scope && session_scope | | ob_enable_aggregation_pushdown | 1 | sys var | cold modified vars | && global_scope && session_scope | | ob_enable_index_direct_select | 0 | sys var | cold modified vars | && global_scope && session_scope | | ob_enable_plan_cache | 1 | sys var | cold modified vars | && global_scope && session_scope | | ob_enable_show_trace | 0 | sys var | cold modified vars | && global_scope && session_scope | | ob_enable_transformation | 1 | sys var | cold modified vars | && global_scope && session_scope | | ob_global_debug_sync | | sys var | cold modified vars | && invisible && session_scope | | ob_interm_result_mem_limit | 2147483648 | sys var | cold modified vars | && global_scope && session_scope | | ob_last_schema_version | 0 | sys var | hot modified vars | && session_scope | | ob_log_level | disabled | sys var | hot modified vars | && global_scope && session_scope | | ob_org_cluster_id | 0 | sys var | cold modified vars | && session_scope | | ob_proxy_partition_hit | 1 | sys var | cold modified vars | && invisible && session_scope && readonly | | ob_proxy_set_trx_executed | 0 | sys var | cold modified vars | && invisible && session_scope && readonly | | ob_query_timeout | 10000000 | sys var | hot modified vars | && global_scope && session_scope | | ob_read_consistency | 3 | sys var | cold modified vars | && global_scope && session_scope | | ob_trx_timeout | 100000000 | sys var | cold modified vars | && global_scope && session_scope | | read_only | 0 | sys var | cold modified vars | && global_scope | | sql_auto_is_null | 0 | sys var | cold modified vars | && global_scope && session_scope | | sql_mode | 4194304 | sys var | cold modified vars | && global_scope && session_scope | | sql_select_limit | 9223372036854775807 | sys var | cold modified vars | && global_scope && session_scope | | sql_warnings | 0 | sys var | cold modified vars | && global_scope && session_scope | | timestamp | 0 | sys var | cold modified vars | && session_scope | | time_zone | +8:00 | sys var | cold modified vars | && global_scope && session_scope | | tx_isolation | READ-COMMITTED | sys var | cold modified vars | && global_scope && session_scope | | tx_read_only | 0 | sys var | cold modified vars | && global_scope && session_scope | | version | 1.0.6 | sys var | cold modified vars | && global_scope && readonly | | version_comment | OceanBase 1.0.6 (r57980-local-f70f8267c28da07e638b124c6909e18883fb98c0) (Built Apr 27 2016 14:32:24) | sys var | cold modified vars | && global_scope && readonly | | wait_timeout | 28800 | sys var | cold modified vars | && global_scope && session_scope | +-----------------------------------+------------------------------------------------------------------------------------------------------+---------+------------------------------+-----------------------------------------------+ 64 rows in set obclient> SHOW PROXYSESSION VARIABLES all 2147549231 like "%id%"; +-------------------+-------+---------+------------------------------+-------------------+ | variable_name | value | info | modified_type | sys_variable_flag | +-------------------+-------+---------+------------------------------+-------------------+ | identity | 0 | sys var | cold modified vars | && session_scope | | last_insert_id | 0 | sys var | last insert id modified vars | && session_scope | | ob_org_cluster_id | 0 | sys var | cold modified vars | && session_scope | +-------------------+-------+---------+------------------------------+-------------------+ 3 rows in set
各字段含义如下表所示：
| 字段 | 说明 |
|---|---|
| variable_name | 变量名 |
| value | 变量值 |
| info | 变量类型（用户变量或系统变量） |
| modified_type | 变量类型（根据修改频率区分） |
| sys_variable_flag | 系统变量范围 |
有关系统变量的详细介绍请参见 系统变量概述，有关用户变量设置，请参见 SET。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/70026124/viewspace-2932695/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 【手摸手玩转 OceanBase 177】如何查看恢复进度？
- 【手摸手玩转 OceanBase 176】取消恢复
- 【手摸手玩转 OceanBase 175】如何执行执行全量恢复
- 【手摸手玩转 OceanBase 174】恢复前准备准备工作有哪些？
- 【手摸手玩转 OceanBase 173】清理备份相关视图介绍
- 【手摸手玩转 OceanBase 172】清理备份相关参数介绍
- 【手摸手玩转 OceanBase 171】如何查看备份清理结果？
- 【手摸手玩转 OceanBase 170】如何查看备份清理进度？
- 【手摸手玩转 OceanBase 169】如何停止清理备份？
- 【手摸手玩转 OceanBase 168】如何自动清理过期备份？
