SHOW CONFIG

    语句用于展示 TiDB 各个组件当前正在应用的配置，请注意，配置与系统变量作用于不同维度，请不要混淆，如果希望获取系统变量信息，请使用 SHOW VARIABLES 语法。

    ShowTargetFilterable:

    显示所有配置：

    1. +------+----------------+-------------------------------------------------+---------------------------------------------------------------------+
    2. | Type | Instance       | Name                                            | Value                                                               |
    3. +------+----------------+-------------------------------------------------+---------------------------------------------------------------------+
    4. | tidb | 127.0.0.1:4000 | advertise-address                               | 127.0.0.1                                                           |
    5. | tidb | 127.0.0.1:4000 | binlog.enable                                   | false                                                               |
    6. ...
    7. 120 rows in set (0.01 sec)

    显示 是 tidb 的配置：

    1. +------+----------------+-------------------+-----------+
    2. | Type | Instance       | Name              | Value     |
    3. +------+----------------+-------------------+-----------+
    4. | tidb | 127.0.0.1:4000 | advertise-address | 127.0.0.1 |
    5. +------+----------------+-------------------+-----------+
    1. +------+----------------+-------------------------------------------------+---------------------------------------------------------------------+
    2. | Type | Instance       | Name                                            | Value                                                               |
    3. +------+----------------+-------------------------------------------------+---------------------------------------------------------------------+
    4. | tidb | 127.0.0.1:4000 | advertise-address                               | 127.0.0.1                                                           |
    5. | tidb | 127.0.0.1:4000 | binlog.binlog-socket                            |                                                                     |
    6. | tidb | 127.0.0.1:4000 | binlog.enable                                   | false                                                               |
    7. ...

    该语句是 TiDB 对 MySQL 语法的扩展。