Parameter diagnostics analyzes the modifiable parameters of your RDS for MySQL instance and recommends tuning adjustments based on instance status, parameter templates, and established benchmarks. Results include a static diagnostics report and the parameter modification history for the last seven days.
Prerequisites
Before you begin, ensure that:
-
Your RDS instance runs MySQL 5.6, MySQL 5.7, or MySQL 8.0.
For RDS Basic Edition instances, run parameter diagnostics in the DAS (Database Autonomy Service) console instead. For more information, see Parameter diagnostics.
Limitations
-
Only one diagnostics task can be triggered within any 3-minute window. If you run two tasks back-to-back, the results may be identical.
-
The feature diagnoses only parameters that are modifiable in the ApsaraDB RDS console. It does not apply changes directly.
How it works
-
The feature retrieves the instance topology and diagnoses the primary instance and any read-only instances separately.
-
It analyzes parameter settings against the instance's current status, parameter templates, benchmark references, calculation formulas, and domain expertise.
-
It returns two outputs: a static parameter diagnostics result, and a record of parameter changes made in the last seven days.
Before applying changes
When you modify parameters based on the diagnostics results, you may need to restart the RDS instance for the modifications to take effect. We recommend that you modify parameters during off-peak hours and make sure that your application is configured to reconnect to the RDS instance.
Billing
No fees are generated.
Run parameter diagnostics
-
Go to the Instances page. In the top navigation bar, select the region where your instance resides, then click the instance ID.
-
In the left-side navigation pane, choose Autonomy Services > Diagnostics.
-
Click the Parameter Diagnostics tab.
-
Click Analyze to start a diagnostics task. The task appears in the Parameter Diagnostics section.
-
After the task completes, find it in the Parameter Diagnostics section and click Details in the Actions column. You can filter results by time period to focus on a specific window. The diagnostics result uses the following recommendation levels:
Level Recommended action Critical Modify the parameter immediately. Warn Modify the parameter based on your business requirements. Notice The parameter value differs from the default parameter template of the RDS instance. -
To apply changes, click Parameter Settings on the diagnostics result page to go to the parameter configuration page. For more information, see Modify the parameters of an ApsaraDB RDS for MySQL instance.