Outdated Version

You are viewing an older version of this section. View current production version.

SHOW GLOBAL VARIABLES

Show the list of global variable bindings.

Syntax

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

Remarks

  • pattern: SQL LIKE clause
  • expr: SQL WHERE clause
  • auto_replicate: This variable exists for backwards compatibility with MySQL and does not affect high availability or replication functionality in MemSQL.
  • This command can be run on any MemSQL node (see Node Requirements for MemSQL Commands).

See SET GLOBAL for more information on these variables.

Output

See the list of engine variables.

Example

memsql> SHOW GLOBAL VARIABLES;
+----------------------------------------------+------------------------------------------------------------------------------+
| Variable_name                                | Value                                                                        |
+----------------------------------------------+------------------------------------------------------------------------------+
| aggregator_failure_detection                 | ON                                                                           |
| auto_replicate                               | OFF                                                                          |
| autocommit                                   | ON                                                                           |
| basedir                                      | /memsql-ops/installs/master-3306                                             |
| character_set_client                         | utf8                                                                         |
| character_set_connection                     | utf8                                                                         |
| character_set_filesystem                     | binary                                                                       |
| character_set_results                        | utf8                                                                         |
| character_set_server                         | utf8                                                                         |
| character_sets_dir                           | /memsql-ops/installs/master-3306/share/charsets/                             |
| collation_connection                         | utf8_general_ci                                                              |
| collation_database                           | utf8_general_ci                                                              |
| collation_server                             | utf8_general_ci                                                              |
| columnar_segment_rows                        | 102400                                                                       |
| columnstore_window_size                      | 2147483648                                                                   |
| compile_only                                 | OFF                                                                          |
| connect_timeout                              | 10                                                                           |
| core_file                                    | ON                                                                           |
| core_file_mode                               | PARTIAL                                                                      |
| critical_diagnostics                         | ON                                                                           |
| datadir                                      | /memsql-ops/installs/master-3306/data                                        |
| default_partitions_per_leaf                  | 8                                                                            |
| enable_experimental_metrics                  | OFF                                                                          |
| explain_expression_limit                     | 500                                                                          |
| flush_before_replicate                       | OFF                                                                          |
| general_log                                  | OFF                                                                          |
| geo_sphere_radius                            | 6367444.657120                                                               |
| hostname                                     | d15b90a9c1ff                                                                 |
| identity                                     | 0                                                                            |
| kerberos_server_keytab                       |                                                                              |
| lc_messages                                  | en_US                                                                        |
| lc_messages_dir                              | /memsql-ops/installs/master-3306/share                                       |
| leaf_failure_detection                       | ON                                                                           |
| load_data_max_buffer_size                    | 1073741823                                                                   |
| load_data_read_size                          | 8192                                                                         |
| load_data_write_size                         | 8192                                                                         |
| lock_wait_timeout                            | 60                                                                           |
| master_aggregator                            | self                                                                         |
| max_allowed_packet                           | 104857600                                                                    |
| max_connection_threads                       | 192                                                                          |
| max_connections                              | 100000                                                                       |
| max_pooled_connections                       | 1024                                                                         |
| max_prefetch_threads                         | 1                                                                            |
| max_prepared_stmt_count                      | 16382                                                                        |
| max_user_connections                         | 0                                                                            |
| maximum_memory                               | 7176                                                                         |
| maximum_table_memory                         | 6152                                                                         |
| memsql_id                                    | B9BFFA49FAC5095C43137060391F5AE8549291F7                                     |
| memsql_version                               | 5.7.1                                                                        |
| memsql_version_date                          | Fri Oct 28 22:39:00 2016 +0000                                               |
| memsql_version_hash                          | 61b72cbf8abf5e4f92e076f3eacd8c4e6e636621                                     |
| minimal_disk_space                           | 100                                                                          |
| multi_insert_tuple_count                     | 20000                                                                        |
| net_buffer_length                            | 102400                                                                       |
| net_read_timeout                             | 3600                                                                         |
| net_write_timeout                            | 3600                                                                         |
| pid_file                                     | /memsql-ops/installs/master-3306/data/memsqld.pid                            |
| pipelines_batches_metadata_to_keep           | 1000                                                                         |
| pipelines_extractor_debug_logging            | OFF                                                                          |
| pipelines_kafka_version                      | 0.8.2.2                                                                      |
| pipelines_max_errors_per_partition           | 1000                                                                         |
| pipelines_max_offsets_per_batch_partition    | 1000000                                                                      |
| pipelines_max_retries_per_batch_partition    | 4                                                                            |
| pipelines_stderr_bufsize                     | 65535                                                                        |
| pipelines_stop_on_error                      | ON                                                                           |
| plan_expiration_minutes                      | 720                                                                          |
| port                                         | 3306                                                                         |
| protocol_version                             | 10                                                                           |
| query_parallelism                            | 0                                                                            |
| redundancy_level                             | 1                                                                            |
| reported_hostname                            |                                                                              |
| secure_file_priv                             |                                                                              |
| show_query_parameters                        | ON                                                                          |
| skip_name_resolve                            | AUTO                                                                         |
| snapshot_trigger_size                        | 268435456                                                                    |
| snapshots_to_keep                            | 2                                                                            |
| socket                                       | /memsql-ops/installs/master-3306/memsql.sock                                 |
| sql_quote_show_create                        | ON                                                                           |
| ssl_ca                                       |                                                                              |
| ssl_capath                                   |                                                                              |
| ssl_cert                                     |                                                                              |
| ssl_cipher                                   |                                                                              |
| ssl_key                                      |                                                                              |
| sync_slave_timeout                           | 20000                                                                        |
| system_time_zone                             | UTC                                                                          |
| thread_cache_size                            | 0                                                                            |
| thread_handling                              | one-thread-per-connection                                                    |
| thread_stack                                 | 1048576                                                                      |
| time_zone                                    | SYSTEM                                                                       |
| tls_version                                  | TLSv1,TLSv1.1,TLSv1.2                                                        |
| tmpdir                                       | .                                                                            |
| transaction_buffer                           | 67108864                                                                     |
| tx_isolation                                 | READ-COMMITTED                                                               |
| use_join_bucket_bit_vector                   | ON                                                                           |
| use_vectorized_join                          | ON                                                                           |
| version                                      | 5.5.8                                                                        |
| version_comment                              | MemSQL source distribution (compatible; MySQL Enterprise & MySQL Commercial) |
| version_compile_machine                      | x86_64                                                                       |
| version_compile_os                           | Linux                                                                        |
| warn_level                                   | WARNINGS                                                                     |
| workload_management                          | ON                                                                           |
| workload_management_expected_aggregators     | 1                                                                            |
| workload_management_max_connections_per_leaf | 1024                                                                         |
| workload_management_max_queue_depth          | 100                                                                          |
| workload_management_max_threads_per_leaf     | 8192                                                                         |
| workload_management_queue_time_warning_ratio | 0.500000                                                                     |
| workload_management_queue_timeout            | 3600                                                                         |
+----------------------------------------------+------------------------------------------------------------------------------+