Skip to content

SHOW VARIABLES

Description

SHOW VARIABLES shows the values of MatrixOne system variables.

Syntax

> SHOW VARIABLES
    [LIKE 'pattern']

Explanations

  • With a LIKE clause, the statement displays only rows for those variables with names that match the pattern.

  • To get a list of variables whose name match a pattern, use the % wildcard character in a LIKE clause.

Examples

```sql mysql> SHOW VARIABLES; +--------------------------+-----------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +--------------------------+-----------------------------------------------------------------------------------------------------------------------+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | | autocommit | 1 | | character_set_client | utf8mb4 | | character_set_connection | utf8mb4 | | character_set_database | utf8mb4 | | character_set_results | utf8mb4 | | character_set_server | utf8mb4 | | collation_connection | default | | collation_server | utf8mb4_bin | | completion_type | NO_CHAIN | | host | 0.0.0.0 | | init_connect | | | interactive_timeout | 28800 | | license | APACHE | | lower_case_table_names | 0 | | max_allowed_packet | 16777216 | | net_write_timeout | 60 | | performance_schema | 0 | | port | 6001 | | profiling | 0 | | query_result_maxsize | 100 | | query_result_timeout | 24 | | save_query_result | 0 | | sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | | sql_safe_updates | 0 | | sql_select_limit | 18446744073709551615 | | system_time_zone | | | testbotchvar_nodyn | 0 | | testbothvar_dyn | 0 | | testglobalvar_dyn | 0 | | testglobalvar_nodyn | 0 | | testsessionvar_dyn | 0 | | testsessionvar_nodyn | 0 | | time_zone | SYSTEM | | transaction_isolation | REPEATABLE-READ | | transaction_read_only | 0 | | tx_isolation | REPEATABLE-READ | | tx_read_only | 0 | | version_comment | MatrixOne | | wait_timeout | 28800 | +--------------------------+-----------------------------------------------------------------------------------------------------------------------+ 41 rows in set (0.01 sec)

mysql> show variables like 'auto%'; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | | autocommit | 1 | +--------------------------+-------+ 3 rows in set (0.00 sec)

mysql> show variables like 'auto_increment_increment'; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | auto_increment_increment | 1 | +--------------------------+-------+ 1 row in set (0.00 sec) ```