This topic describes how to view the parameters of an ApsaraDB RDS for MySQL instance in the ApsaraDB RDS console or by using an SQL statement.

Method 1: View the parameters of an RDS instance in the ApsaraDB RDS console

  1. Visit the RDS instance list, select a region above, and click the target instance ID.
  2. In the left-side navigation pane, click Parameters. On the Editable Parameters tab of the page that appears, view the value of each parameter.
    Note The ApsaraDB RDS console displays only the parameters that you can configure. For more information about how to view all parameters, see the "Method 2: View the parameters of an RDS instance by using an SQL statement" section of this topic.

Method 2: View the parameters of an RDS instance by using an SQL statement

  1. Connect to the RDS instance. For more information, see Connect to an ApsaraDB RDS for MySQL instance.
  2. Execute the following statement to view all the parameters of the RDS instance.
    SHOW VARIABLES;
    You can also execute the SHOW VARIABLES LIKE '<Parameter name>'; statement to view only a specific parameter.
    Note The <Parameter name> variable supports wildcards (%). You can insert a wildcard (%) into any part of the <Parameter name> variable. A wildcard (%) can represent any number of characters. Examples:
    • The SHOW VARIABLES LIKE 'thread_cache%'; statement queries all parameters whose names start with thread_cache.
    • The SHOW VARIABLES LIKE '%cache_size'; statement queries all parameters whose names end with cache_size.
    • The SHOW VARIABLES LIKE 'thread%size'; statement queries all parameters whose names start with thread and end with size.
    • The SHOW VARIABLES LIKE '%'; statement is equivalent to the SHOW VARIABLES; statement.

Related operations

Operation Description
Query parameter configurations Queries the parameters of an ApsaraDB RDS instance.
Modify parameters of an ApsaraDB for RDS instance Reconfigures the parameters of an ApsaraDB RDS instance.
Query the parameter template of an ApsaraDB for RDS instance Queries the parameter templates that are available for an ApsaraDB RDS instance.