Syntax

SHOW [CLUSTER] [LOCAL|GLOBAL] VARIABLES [EXTENDED]
[LIKE 'pattern' | WHERE expression]

Arguments

• pattern - Can contain the % wildcard which represents zero or more characters. Can also contain the _ wildcard which represents one character.

• expression - A SQL WHERE clause.

• See the Permission Matrix for the required permission.

Remarks

• CLUSTER - Displays the list of variables that can sync to all nodes. _SYNC and CLUSTER are synonymous. Use either of the options in the command.

• LOCAL- Displays the list of variable bindings in the current connection to the node. This includes the values of global variables that have been set. Values of session variables that can be set globally are not included, when these variables are set globally.

• SESSION and LOCAL are synonymous. Use either of the options in the command.

• GLOBAL - Displays the list of global variable bindings. Values of session variables that can be set globally are also included, when these variables are set globally.

• If the _SYNC|CLUSTER option is specified, GLOBAL variables are shown by default.

• If the _SYNC|CLUSTER option is not specified, LOCAL variables are shown by default.

• EXTENDED - Displays additional information about the variables in the output.

  • Cluster_type - If the variable is global, has the same value as Variable_type. If the variable is a session variable that can also be set globally, displays the type of sync variable. If the variable is not a sync variable, the value is Local.

  • Variable_type - Displays the type of sync variable. For non-sync variables and session variables that can also be set globally, the value is Local.

• This command can be run on any SingleStore node (see Node Requirements for SingleStore Commands).

Examples

SHOW VARIABLES LIKE 'auto%';

+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| auto_attach              | ON    |
| auto_increment_increment | 1     |
| auto_increment_offset    | 1     |
| auto_replicate           | OFF   |
| autocommit               | ON    |
+--------------------------+-------+

SET GLOBAL connect_timeout = 20;

SHOW LOCAL VARIABLES LIKE 'connect_timeout';

+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| connect_timeout | 20    |
+-----------------+-------+

SET GLOBAL enable_broadcast_left_join = OFF;

SHOW LOCAL VARIABLES LIKE 'enable_broadcast_left_join';

+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| enable_broadcast_left_join | ON    |
+----------------------------+-------+

SHOW VARIABLES EXTENDED LIKE 'character_set_server';

+----------------------+-------+---------------+----------------------------+---------------+
| Variable_name        | Value | Variable_type | Cluster_type               | In_Allow_List |
+----------------------+-------+---------------+----------------------------+---------------+
| character_set_server | utf8  | Local         | Cluster-wide for all nodes | Yes           |
+----------------------+-------+---------------+----------------------------+---------------+

SHOW VARIABLES EXTENDED LIKE 'memsql_version';

+----------------+-------+---------------+--------------+---------------+
| Variable_name  | Value | Variable_type | Cluster_type | In_Allow_List |
+----------------+-------+---------------+--------------+---------------+
| memsql_version | 7.8.0 | Local         | Local        | No            |
+----------------+-------+---------------+--------------+---------------+

See Also

• Engine variables overview