SHOW SQL_PARSER RULE

Description

The SHOW SQL_PARSER RULE syntax is used to query sql parser rule configuration.

Syntax

Grammar Railroad diagram

  1. ShowSqlParserRule ::=
  2.   'SHOW' 'SQL_PARSER' 'RULE'

Return Value Description

ColumnDescription
parse_tree_cacheparse tree cache configuration
sql_statement_cacheSQL statement cache configuration

Example

  • Query sql parser rule configuration
  1. SHOW SQL_PARSER RULE;
  1. mysql> SHOW SQL_PARSER RULE;
  2. +-----------------------------------------+-------------------------------------------+
  3. | parse_tree_cache                        | sql_statement_cache                       |
  4. +-----------------------------------------+-------------------------------------------+
  5. | initialCapacity: 128, maximumSize: 1024 | initialCapacity: 2000, maximumSize: 65535 |
  6. +-----------------------------------------+-------------------------------------------+
  7. 1 row in set (0.05 sec)

Reserved word

SHOW, SQL_PARSER, RULE