This topic describes how to use the SHOW ADB CONFIG statement to view the configuration parameters of an AnalyticDB for MySQL cluster.
Prerequisites
An AnalyticDB for MySQL Data Lakehouse Edition or Data Warehouse Edition cluster that runs the minor engine version 3.1.6.0 or later is created.
Syntax
SHOW ADB_CONFIG KEY=[resource_group_name.]config_name;
Parameters
resource_group_name
: the name of the resource group. You can specify the name of a resource group to query the configuration parameters of the resource group. If you do not specify this parameter, global configuration parameters are returned. This parameter is optional.config_name
: the name of the configuration parameter. For more information about the valid values, see Common configuration parameters. This parameter is required.
Return values
If you have manually configured the configuration parameters, the specified values are returned.
If you have not manually configured the configuration parameters, the default values are returned.
If you have manually configured global configuration parameters but not resource group-level ones, the specified values of global configuration parameters take effect. When you execute the SHOW ADB_CONFIG
statement to query resource group-level configuration parameters, their default values are returned. Given that the values that take effect and the return values of the SHOW ADB_CONFIG
statement are inconsistent, you must query both the resource group-level configuration parameters and global configuration parameters.
Examples
Query the query timeout period of the current cluster.
SHOW ADB_CONFIG KEY=query_timeout;
The following information is returned:
+---------------+---------+
| key | value |
+---------------+---------+
| QUERY_TIMEOUT | 1800000 |
+---------------+---------+
1 row in set (0.06 sec)
Query the query timeout period of the user_default resource group.
SHOW ADB_CONFIG KEY=user_default.query_timeout;
The following information is returned:
+----------------------------+---------+
| key | value |
+----------------------------+---------+
| USER_DEFAULT.QUERY_TIMEOUT | 1800000 |
+----------------------------+---------+
1 row in set (0.06 sec)