Help Center/ TaurusDB/ User Guide/ Parameter Management/ Viewing Parameters of a DB Instance

Updated on 2025-08-29 GMT+08:00

View PDF

Viewing Parameters of a DB Instance

You can view the parameter settings of your DB instance on the console or through the CLI.

You can only view the parameters in the parameter list on the console. To view all parameters of a DB instance, see Viewing Parameters of a DB Instance Through the CLI.

Log in to the management console.
Click in the upper left corner and select a region and project.
Click in the upper left corner of the page and choose Databases > TaurusDB.
On the Instances page, click the instance name.
In the navigation pane, choose Parameters.

Alternatively, click in the upper right corner of the Basic Information page and choose Modify Parameters.

Figure 1 Choosing Modify Parameters
On the Parameters tab, set Query By to Instance (default value) or Node to view the parameter settings of the current instance or node.

Figure 2 Viewing parameters of a DB instance

You can search for the desired parameter by parameter name.

Connect to a DB instance.

For details about the connection methods, see Connection Methods.
Run the following command to view all parameter settings of the DB instance:
```
SHOW VARIABLES;
```
Run the following command to view the setting of a specified parameter:
```
SHOW VARIABLES LIKE '<parameter-name>';
```
A percent sign (%) can appear anywhere in <parameter_name> for fuzzy search. Examples:
- Querying all parameters that start with binlog
```
SHOW VARIABLES LIKE 'binlog%';
```
- Querying all parameters that end with binlog
```
SHOW VARIABLES LIKE '%binlog';
```
- Querying all parameters that start with thread and end with size
```
SHOW VARIABLES LIKE 'thread%size';
```
- Querying all parameters
```
SHOW VARIABLES LIKE '%';
```