All Products
Search
Document Center

AnalyticDB:SHOW ADB_CONFIG

Last Updated:Mar 02, 2023

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.

Note For more information about how to view the minor engine version of a cluster, see How can I view the version of an AnalyticDB for MySQL cluster? To update the minor engine version of a cluster, contact technical support.

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.

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)