Retro Eye care Haitian Deep Dark Default

SHOW SQL_FEDERATION RULE

Description

The SHOW SQL_FEDERATION RULE syntax is used to query the federated query configuration.

Syntax

ShowSQLFederationRule ::=
  'SHOW' 'SQL_FEDERATION' 'RULE'

Return Value Description

Column Description
sql_federation_enabled SQL federation enabled configuration
all_query_use_sql_federation all query use SQL federation configuration
execution_plan_cache execution plan cache configuration

Example

  • Query sql federation rule configuration
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)

Reserved word

SHOW、SQL_FEDERATION、RULE