ApsaraDB RDS:Use the parameter diagnostics feature for an ApsaraDB RDS for MySQL instance

Background

Database performance optimization is one of the most important researches in industry and academia. In addition to optimization to business code and SQL statements, including index optimization, parameter tuning is an efficient manner to improve database performance.

Prerequisites

The RDS instance runs MySQL 5.6, MySQL 5.7, or MySQL 8.0.

Limits

• Only one parameter diagnostics task can be triggered within 3 minutes.

• The parameter diagnostics feature only diagnoses the parameters that can be modified in the ApsaraDB RDS console and provides diagnostics results. The feature does not directly modify parameters.

• If two consecutive parameter diagnostics tasks span a short period of time, the returned results may be the same.

Implementation

1. Obtain the instance topology and separately diagnose the parameters of the primary RDS instance and the read-only RDS instances (if any).

2. Analyze the parameter settings of the database instance based on the status of the instance, parameter templates, benchmark concepts related to additional parameters, calculation formulas, and expertise.

3. Provide the diagnostics result. The diagnostics result consists of the static parameter diagnostics result and the parameter modification history within the last seven days.

Usage notes

When you modify the parameters of an RDS instance based on the diagnostics results, you may need to restart the RDS instance for the modifications to take effect. We recommend that you modify the parameters during off-peak hours and make sure that your application is configured to reconnect to the RDS instance.

Billing rules

No fees are generated.

Procedure

1. 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.

2. In the left-side navigation pane, choose Autonomy Services > Diagnostics.

3. Click the Parameter Diagnostics tab to diagnose instance parameters.

   • Create a parameter diagnostics task

     Click Analyze to create a parameter diagnostics task. You can view the diagnostics task in the Parameter Diagnostics section.

   • View the parameter diagnostics result

     In the Parameter Diagnostics section, find the diagnostics task that you want to view and click Details in the Actions column.

     You can specify a period of time within which you want to view the parameter diagnostics result.

     Note

     • If you want to modify the parameters based on the diagnostics result, click Parameter Settings on the diagnostics result page to go to the ApsaraDB RDS console. For more information, see Modify instance parameters.

     • The following section describes the recommendation levels in the diagnostics result:

       • Critical: We recommend that you immediately modify the parameter.

       • Warn: We recommend that you modify the parameter based on your business requirements.

       • Notice: The value of this parameter is different from that in the default parameter template of the RDS instance.