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

Updated on 2024-11-06 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 > GaussDB(for MySQL).
On the Instances page, click the instance name.
In the navigation pane, choose Parameters.
On the Parameters tab, view the parameter settings of the DB instance.

Figure 1 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 method, see Overview.
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 '%';