Use the SHOW ADB CONFIG statement to view the configuration parameters of an AnalyticDB for MySQL cluster - AnalyticDB

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 cluster of V3.1.6.0 or later is created.

Note

Note
To query the minor version of an AnalyticDB for MySQL Data Lakehouse Edition cluster, execute the SELECT adb_version(); statement. To update the minor version of a cluster, contact technical support.
Note
For information about how to view and update the minor version of an AnalyticDB for MySQL Data Warehouse Edition cluster, see Update the minor version of a cluster.

Syntax

SHOW ADB_CONFIG KEY=[resource_group_name.]config_name;

Important

To identify the names of configuration parameters of a resource group, enclose the resource_group_name.config_name parameter in single quotation marks (').

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 Config and hint configuration parameters.

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.

Important

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)