ADMIN SHOW CONFIG

Description

Displays the configuration of the current cluster (currently only FE configuration items are supported).

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 

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)

Keyword

ADMIN,SHOW,CONFIG