ApsaraDB RDS for MySQL provides two ways to inspect parameter values: the console shows all editable parameters at a glance, and SQL statements give you the full parameter list, including read-only system parameters.
Prerequisites
Before you begin, make sure that you have:
An ApsaraDB RDS for MySQL instance
(For the SQL method) A database account with permission to connect to the instance
Method 1: View parameters in the console
Go to the RDS instance list, select a region, and click the target instance ID.
In the left-side navigation pane, click Parameters.
On the Editable Parameters tab, review the current value of each parameter.
The console displays only parameters that you can configure. To view all parameters—including read-only system parameters—use the SQL method described below.
Method 2: View parameters using SQL
Connect to your ApsaraDB RDS for MySQL instance before running any of the following statements.
List all parameters
Run the following statement to return every parameter and its current value:
SHOW VARIABLES;Filter by parameter name
To query a specific parameter, append a LIKE clause:
SHOW VARIABLES LIKE '<parameter-name>';Replace <parameter-name> with the exact parameter name or a pattern that uses the % wildcard. The wildcard matches any number of characters and can appear anywhere in the name.
| Pattern | Returns |
|---|---|
SHOW VARIABLES LIKE 'thread_cache%'; | All parameters whose names start with thread_cache |
SHOW VARIABLES LIKE '%cache_size'; | All parameters whose names end with cache_size |
SHOW VARIABLES LIKE 'thread%size'; | All parameters whose names start with thread and end with size |
SHOW VARIABLES LIKE '%'; | All parameters (equivalent to SHOW VARIABLES;) |
What's next
Reconfigure the parameters of an ApsaraDB RDS for MySQL instance — modify parameter values in the console or via the API.
Use a parameter template to manage parameters — apply a saved set of parameters across multiple instances.
Optimize parameters of an ApsaraDB RDS for MySQL instance — recommendations for key parameter values.