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