During the daily O&M of ApsaraDB RDS for MySQL or the handling of instance failures, you must view related performance metrics. ApsaraDB RDS for MySQL provides various performance metrics, multiple monitoring views, and powerful diagnostic capabilities. This helps detect database anomalies at the earliest opportunity and provides required troubleshooting methods.
Prerequisites
Your RDS instance runs one of the following MySQL versions and RDS editions:
MySQL 8.0 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster Edition
MySQL 5.7 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster Edition
MySQL 5.6 on RDS High-availability Edition
MySQL 5.5 on RDS High-availability Edition
Feature description
The dashboard feature supports various metrics such as TPS, QPS, and throughput.
The dashboard feature displays metrics by monitoring granularity or monitoring frequency. The monitoring frequency varies based on the time range that you specified to perform a query. If the time range that you specified is long, the monitoring frequency is low. If the time range that you specified to perform a query is within five minutes, the monitoring frequency is once every second, which is the highest monitoring frequency.
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 .
On the Performance Trends tab, you can view the trend charts of metrics within a specific time range.
You can click More Metrics and select the metrics that you want to view.
You can drag and select a time range in the trend chart of a metric and click Diagnose to analyze the performance trend of the metric within the selected time range.
You can click Details in the trend chart of a metric to expand the chart. You can also change the time range to view the change trends of the metric within different time ranges.
Select the level of events that you want to view. When the system detects events at the specified level, the system displays the events in the MySQL CPU Utilization/Memory Usage and Session charts.
You can click an event in a trend chart to view the diagnosis result in the event details.
On the Performance Trend Comparison tab, you can view the comparison of performance trends for a metric within different time ranges.
You can click More Metrics and select the metrics that you want to view.
On the Custom Charts tab, you can create dashboards to display the performance metrics that you want to view. When you create a chart, you can specify multiple performance metrics that you want the chart to display. This way, you can analyze metrics that are displayed on the dashboards and troubleshoot performance issues.
Click Add Monitoring Dashboard. In the Create Monitoring Dashboard dialog box, configure the Dashboard Name parameter and click OK.
Click Select Instances and Metrics, select the required nodes and metrics that you want to view, and then click the
icon. Click Confirm.
On the Exception Detection tab, you can view the results of exception detection and predictions for core metrics. For more information, see Performance anomaly detection.
You can click More Metrics and select the metrics based on which you want to detect exceptions.
On the Instance Topology tab, you can view the topology of the instance.
References
The following topics provide troubleshooting methods for common performance issues:
You can use the autonomy service-related features to perform performance diagnosis and optimization on your RDS instance. For more information, see Overview of DAS.