Product Solutions Support
Try MemSQL

SHOW SESSION VARIABLES

Show the list of variable bindings currently in the session.

SHOW SESSION VARIABLES
[LIKE 'pattern' | WHERE expr]

Notes

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)
Was this article useful?