ADMIN SHOW CONFIG

ADMIN SHOW CONFIG displays the configuration of the current cluster (Currently, only FE configuration items can be displayed). For detailed description of these configuration items, see Configuration.

If you want to set or modify a configuration item, use ADMIN SET CONFIG.

tip

This operation requires the SYSTEM-level OPERATE privilege. You can follow the instructions in GRANT to grant this privilege.

Syntax

ADMIN SHOW FRONTEND CONFIG [LIKE "pattern"]

Note:

Description of the return parameters:

1. Key:        Configuration item name
2. Value:      Configuration item value
3. Type:       Configuration item type 
4. IsMutable:  Whether it can be set through the ADMIN SET CONFIG command
5. MasterOnly: Whether it only applies to leader FE
6. Comment:    Configuration item description 

For configuration items that hold credentials, such as passwords, secret keys, and tokens, Value does not show the actual value. If the item is set, Value is ******. If the item is not set, Value is empty. Masking affects only the output. The FE still uses the actual value.

Examples

1. View the configuration of the current FE node.

   ADMIN SHOW FRONTEND CONFIG;

2. Search for the configuration of the current FE node by using the like predicate.

   mysql> ADMIN SHOW FRONTEND CONFIG LIKE '%check_java_version%';
   +--------------------+-------+---------+-----------+------------+---------+
   | Key                | Value | Type    | IsMutable | MasterOnly | Comment |
   +--------------------+-------+---------+-----------+------------+---------+
   | check_java_version | true  | boolean | false     | false      |         |
   +--------------------+-------+---------+-----------+------------+---------+
   1 row in set (0.00 sec)