SHOW ADB_CONFIG returns the current value of a configuration item in your AnalyticDB for MySQL cluster—either at the global level or for a specific resource group.
Prerequisites
Before you begin, ensure that you have:
Kernel version 3.1.6.0 or later. To check or update the minor version, go to the AnalyticDB for MySQL console, open the Cluster Information page, and find the Configuration Information section.
Syntax
SHOW ADB_CONFIG KEY=[resource_group_name.]config_name;Parameters
| Parameter | Required | Description |
|---|---|---|
resource_group_name | No | The resource group to query. Omit this parameter to query global configuration values. When included, enclose resource_group_name.config_name together in single quotation marks ('); otherwise the system cannot parse the configuration item name. |
config_name | Yes | The name of the configuration item. For a full list, see Config and Hint configuration parameters. |
Return value
The command returns the value of the specified configuration item.
If the item has been manually set, the configured value is returned.
If the item has not been manually set, the default value is returned.
Examples
Query a global configuration item
SHOW ADB_CONFIG KEY=query_timeout;Output:
+---------------+---------+
| key | value |
+---------------+---------+
| QUERY_TIMEOUT | 1800000 |
+---------------+---------+
1 row in set (0.06 sec)Query a resource group configuration item
Enclose the full key in single quotation marks when querying a resource group.
SHOW ADB_CONFIG KEY='user_default.query_timeout';Output:
+----------------------------+---------+
| key | value |
+----------------------------+---------+
| USER_DEFAULT.QUERY_TIMEOUT | 1800000 |
+----------------------------+---------+
1 row in set (0.06 sec)Usage notes
Global and resource group values may differ. If you have configured a global parameter but not the corresponding resource group-level parameter, the global value takes effect at runtime. However, SHOW ADB_CONFIG for the resource group-level parameter returns the default value—not the global value. To confirm which value is in effect, query both levels and compare:
-- Query the global value
SHOW ADB_CONFIG KEY=query_timeout;
-- Query the resource group value
SHOW ADB_CONFIG KEY='user_default.query_timeout';If the resource group query returns the default value, the global setting is what takes effect.
Related topics
Config and Hint configuration parameters — browse all available configuration items