# Displaying TiDB Configuration File Parameters

__*TiDB system configuration view*__
__*TiDB cluster configuration view*__
__*View TiDB system parameters*__
__*View TiDB cluster parameters*__
__*zz-BGL*__
__*zz-Jeff*__


+ **`SHOW CONFIG`** statement displays the parameters in effect for the cluster
+ **`Type`** can be **`tidb`**, **`tikv`**, **`pd`** or **`tiflash`**
+ For example:
```
tidb> ~!@SHOW CONFIG@!~ WHERE type IN ('tidb', 'tikv') AND name='log.format';
+------+-----------------+------------+-------+
| Type | Instance        | Name       | Value |
+------+-----------------+------------+-------+
| tidb | 127.0.0.1:4000  | log.format | text  |
| tidb | 127.0.0.1:4001  | log.format | text  |
| tidb | 127.0.0.1:4002  | log.format | text  |
| tidb | 127.0.0.1:4002  | log.format | text  |
| tidb | 127.0.0.1:4000  | log.format | text  |
| tikv | 127.0.0.1:20161 | log.format | text  |
| tikv | 127.0.0.1:20160 | log.format | text  |
| tikv | 127.0.0.1:20162 | log.format | text  |
+------+-----------------+------------+-------+
8 rows in set (0.01 sec)
```

-------------------------------------------------------------
You can view the configuration information of all instances in the cluster by using the `SQL` statement `show config`. The results are as follows:

You can also filter the display by column, such as:

```
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';
```