SHOW DIST VARIABLE

Description

The SHOW DIST VARIABLE syntax is used to query PROXY system variables configuration.

Syntax

Grammar Railroad diagram

  1. ShowDistVariable ::=
  2.   'SHOW' ('VARIABLES' | 'VARIABLE' 'WHERE' 'NAME' '=' variableName)
  4. variableName ::=
  5.   identifier

Return Value Description

ColumnsDescription
variable_namesystem variable name
variable_valuesysten variable value

Supplement

  • When variableName is not specified, the default is query all PROXY variables configuration.

Example

  • Query all system variables configuration of PROXY
  1. SHOW DIST VARIABLES;
  1. mysql> SHOW DIST VARIABLES;
  2. +---------------------------------------+----------------+
  3. | variable_name                         | variable_value |
  4. +---------------------------------------+----------------+
  5. | system_log_level                      | INFO           |
  6. | kernel_executor_size                  | 0              |
  7. | max_connections_size_per_query        | 1              |
  8. | check_table_meta_data_enabled         | false          |
  9. | sql_federation_type                   | NONE           |
  10. | proxy_frontend_database_protocol_type |                |
  11. | proxy_frontend_flush_threshold        | 128            |
  12. | proxy_hint_enabled                    | false          |
  13. | proxy_backend_query_fetch_size        | -1             |
  14. | proxy_frontend_executor_size          | 0              |
  15. | proxy_backend_executor_suitable       | OLAP           |
  16. | proxy_frontend_max_connections        | 0              |
  17. | proxy_mysql_default_version           | 5.7.22         |
  18. | proxy_default_port                    | 3307           |
  19. | proxy_netty_backlog                   | 1024           |
  20. | proxy_instance_type                   | Proxy          |
  21. | cdc_server_port                       | 33071          |
  22. | proxy_meta_data_collector_enabled     | true           |
  23. | agent_plugins_enabled                 | true           |
  24. | cached_connections                    | 0              |
  25. | transaction_type                      | LOCAL          |
  26. | sql_show                              | false          |
  27. | sql_simple                            | false          |
  28. +---------------------------------------+----------------+
  29. 23 rows in set (0.01 sec)
  • Query specified system variable configuration of PROXY
  1. SHOW DIST VARIABLE WHERE NAME = sql_show;
  1. mysql> SHOW DIST VARIABLE WHERE NAME = sql_show;
  2. +---------------+----------------+
  3. | variable_name | variable_value |
  4. +---------------+----------------+
  5. | sql_show      | false          |
  6. +---------------+----------------+
  7. 1 row in set (0.00 sec)

Reserved word

SHOW, DIST, VARIABLE, VARIABLES, NAME