SHOW SQL_PARSER RULE 语法用于查询解析引擎规则配置
ShowSqlParserRule ::=
'SHOW' 'SQL_PARSER' 'RULE'
| 列 | 说明 |
|---|---|
| sql_comment_parse_enable | sql注释解析启用状态 |
| parse_tree_cache | 语法树缓存 |
| sql_statement_cache | sql语句缓存 |
SHOW SQL_PARSER RULE;
mysql> SHOW SQL_PARSER RULE;
+--------------------------+-----------------------------------------+-------------------------------------------+
| sql_comment_parse_enable | parse_tree_cache | sql_statement_cache |
+--------------------------+-----------------------------------------+-------------------------------------------+
| false | initialCapacity: 128, maximumSize: 1024 | initialCapacity: 2000, maximumSize: 65535 |
+--------------------------+-----------------------------------------+-------------------------------------------+
1 row in set (0.05 sec)
SHOW、SQL_PARSER、RULE