Viewing Parameters of a DB Instance

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

Figure 1 Viewing parameters of a DB instance

You can enter a parameter name in the search box to quickly search for the desired parameter and view its settings.

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>';
The percent sign (%) can be used in <parameter_name> for fuzzy search. The percent sign can appear anywhere in <parameter_name>. 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 '%';