Outdated Version
You are viewing an older version of this section. View current production version.
SHOW SESSION VARIABLES
Show the list of variable bindings currently in the session.
SHOW SESSION STATUS
[LIKE 'pattern' | WHERE expr]
Notes
pattern- SQL LIKE clauseexpr- SQL WHERE clause- This command can be run on any MemSQL node (see Node Requirements for MemSQL Commands).
Output
See System Variables.
Example
memsql> SHOW SESSION VARIABLES;
+------------------------------+------------------------------------------------------------------------------+
| Variable_name | Value |
+------------------------------+------------------------------------------------------------------------------+
| aggregator_failure_detection | ON |
| autocommit | ON |
| basedir | . |
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /var/lib/memsql/share/charsets/ |
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
| compile_only | OFF |
| connect_timeout | 10 |
| core-file | ON |
| critical_diagnostics | OFF |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_partitions_per_leaf | 8 |
| durability | on |
| error_count | 0 |
| external_user | |
| flat_plancache | OFF |
| flush-before-replicate | OFF |
| general_log | OFF |
| hostname | lammergeyer |
| interactive_timeout | 28800 |
| kerberos_server_keytab | |
| lc_messages | en_US |
| lc_messages_dir | /var/lib/memsql/share/ |
| lc_time_names | en_US |
| leaf_failure_detection | ON |
| load_data_batch_size | 50 |
| local_infile | ON |
| lock_wait_timeout | 60 |
| locked_in_memory | OFF |
| master_aggregator | |
| max_allowed_packet | 1048576 |
| max_connections | 8192 |
| max_pooled_connections | 256 |
| max_user_connections | 0 |
| maximum_memory | 48290 |
| maximum_table_memory | 43461 |
| memsql_version | 2.6 |
| memsql_version_hash | 933723486101cb9b09fd2740237f29a94c6eaf40 |
| net_buffer_length | 16384 |
| net_read_timeout | 3600 |
| net_retry_count | 10 |
| net_write_timeout | 3600 |
| pid_file | /var/lib/memsql/memsql.pid |
| plan_expiration_minutes | 720 |
| port | 3306 |
| protocol_version | 10 |
| proxy_user | |
| query_parallelism | 0 |
| redundancy_level | 1 |
| reported_hostname | |
| secure_file_priv | |
| snapshot-trigger-size | 268435456 |
| snapshots-to-keep | 2 |
| socket | memsql.sock |
| sql_quote_show_create | ON |
| sync-slave-timeout | 10000 |
| system_time_zone | PST |
| table_precompiled_header | ON |
| thread_cache_size | 0 |
| thread_handling | one-thread-per-connection |
| thread_stack | 1048576 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timestamp | 1391112305 |
| tmpdir | . |
| transaction-buffer | 67108864 |
| tx_isolation | READ-COMMITTED |
| version | 5.5.8 |
| version_comment | MemSQL source distribution (compatible; MySQL Enterprise & MySQL Commercial) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| wait_timeout | 28800 |
| warn_level | WARNINGS |
| warning_count | 0 |
+------------------------------+------------------------------------------------------------------------------+
82 rows in set (0.00 sec)
