SHOW SQL_FEDERATION RULE 语法用于查询联邦查询配置。
ShowSQLFederationRule ::=
'SHOW' 'SQL_FEDERATION' 'RULE'
| 列 | 说明 |
|---|---|
| sql_federation_enabled | 是否开启联邦查询 |
| all_query_use_sql_federation | 是否全部查询 SQL 使用联邦查询 |
| execution_plan_cache | 执行计划缓存 |
SHOW SQL_FEDERATION RULE;
mysql> show sql_federation rule;
+------------------------+------------------------------+-------------------------------------------+
| sql_federation_enabled | all_query_use_sql_federation | execution_plan_cache |
+------------------------+------------------------------+-------------------------------------------+
| true | false | initialCapacity: 2000, maximumSize: 65535 |
+------------------------+------------------------------+-------------------------------------------+
1 row in set (0.31 sec)
SHOW、SQL_FEDERATION、RULE