SHOW SQL_PARSER RULE 语法用于查询解析引擎规则配置。
ShowSqlParserRule ::=
'SHOW' 'SQL_PARSER' 'RULE'
| 列 | 说明 |
|---|---|
| sql_comment_parse_enabled | SQL 注释解析启用状态 |
| parse_tree_cache | 语法树缓存 |
| sql_statement_cache | SQL 语句缓存 |
SHOW SQL_PARSER RULE;
mysql> SHOW SQL_PARSER RULE;
+---------------------------+-----------------------------------------+-------------------------------------------+
| sql_comment_parse_enabled | 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