Retro Eye care Haitian Deep Dark Default

SHOW SQL_PARSER RULE

Description

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

Syntax

ShowSqlParserRule ::=
  'SHOW' 'SQL_PARSER' 'RULE'

Return Value Description

Column Description
parse_tree_cache parse tree cache configuration
sql_statement_cache SQL statement cache configuration

Example

  • Query sql parser rule configuration
SHOW SQL_PARSER RULE;

mysql> SHOW SQL_PARSER RULE;
+-----------------------------------------+-------------------------------------------+
| parse_tree_cache                        | sql_statement_cache                       |
+-----------------------------------------+-------------------------------------------+
| initialCapacity: 128, maximumSize: 1024 | initialCapacity: 2000, maximumSize: 65535 |
+-----------------------------------------+-------------------------------------------+
1 row in set (0.05 sec)

Reserved word

SHOW, SQL_PARSER, RULE