Outdated Version
You are viewing an older version of this section. View current production version.
SHOW VARIABLES
Show the list of variable bindings.
SHOW VARIABLES
[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 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)
