Diagnose parameters of an RDS for MySQL instance-ApsaraDB RDS(RDS)-阿里云帮助中心

Tuning database parameters is an effective method for optimizing database performance. The parameter diagnostics feature allows you to diagnose the parameters of your RDS for MySQL instance that are modifiable in the ApsaraDB RDS console. This feature provides optimization recommendations and a seven-day history of parameter modifications.

Background

Database performance optimization is a key area of research in both industry and academia. In addition to optimizing SQL queries (such as index optimization) and application logic, tuning database parameters is an effective way to improve database performance.

Prerequisites

Your database instance runs RDS for MySQL 5.6, 5.7, 8.0, or 8.4.

Note

For Basic Edition instances, you can run parameter diagnostics in the DAS console. For more information, see parameter diagnostics.

Limitations

You can trigger a parameter diagnostics task only once every three minutes.
The parameter diagnostics feature analyzes only modifiable parameters in the ApsaraDB RDS console and provides diagnostic results without applying changes.
Running a new diagnostic task immediately after a previous one may yield identical results.

How it works

Retrieves instance topology information and analyzes the primary instance and any read-only instances separately.
Analyzes the parameter settings of the instance based on its status information, the parameter template, relevant benchmark concepts, calculation formulas, and domain expertise.
Outputs the analysis results. The results include static parameter diagnostics for the instance and the parameter modification history from the last seven days.

Usage notes

When you modify RDS for MySQL parameters based on the analysis results, some parameters may require an instance restart to take effect. We recommend performing these operations during off-peak hours and ensuring your application has a reconnection mechanism.

Note

The parameter diagnostics feature analyzes only the parameters that can be modified in the ApsaraDB RDS console and provides diagnostic results. It does not modify parameters directly. To modify parameters, go to the ApsaraDB RDS console. For more information, see Modify the parameters of an ApsaraDB RDS for MySQL instance.

Billing

This feature is free of charge.

Procedure

Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the left-side navigation pane, choose Autonomy Services > Diagnostics.
Click the Parameter Diagnostics tab to diagnose the instance parameters.
- Create a parameter diagnostics task
  Click Analyze Now to create a parameter diagnostics task. The new task appears in the Parameter Diagnostics list.
- View parameter diagnostic results
  In the Parameter Diagnostics list, click Details for the desired task to view the diagnostic results.
  You can select a time range to view historical diagnostic records.
  Note
  - To modify parameters based on the diagnostic results, click Parameter Settings on the results page to go to the ApsaraDB RDS console. For detailed instructions, see Modify the parameters of an ApsaraDB RDS for MySQL instance.
  - The Recommendation Level in the diagnostics results indicates the severity:
    Critical: Modify the parameter immediately.
    Warn: Modify the parameter based on your business requirements.
    Notice: The parameter value differs from the value in the default parameter template of the RDS for MySQL instance.