# TiDB 配置参数的查看

__*TiDB 系统配置查看*__
__*TiDB 集群配置查看*__
__*TiDB 系统参数查看*__
__*TiDB 集群参数查看*__

+ 可以通过 SQL语句 show config 来直接查看集群所有实例的配置信息:
  + `show config`;

-------------------------------------------------------------
可以通过 SQL语句 show config 来直接查看集群所有实例的配置信息,结果如下:
```
show config;
```
+------+-----------------+-----------------------------------------------------------+------------------------------+
| Type | Instance        | Name                                                      | Value                        |
+------+-----------------+-----------------------------------------------------------+------------------------------+
| tidb | 127.0.0.1:4001  | advertise-address                                         | 127.0.0.1                    |
| tidb | 127.0.0.1:4001  | binlog.binlog-socket                                      |                              |
| tidb | 127.0.0.1:4001  | binlog.enable                                             | false                        |
| tidb | 127.0.0.1:4001  | binlog.ignore-error                                       | false                        |
| tidb | 127.0.0.1:4001  | binlog.strategy                                           | range                        |
| tidb | 127.0.0.1:4001  | binlog.write-timeout                                      | 15s                          |
| tidb | 127.0.0.1:4001  | check-mb4-value-in-utf8                                   | true                         |
...

还可以根据对应的字段进行过滤,如:

show config where type='tidb'

show config where instance in (...)

show config where name like '%log%'

show config where type='tikv' and name='log-level'