All Products
Search
Document Center

ApsaraDB RDS:Use the dashboard feature for an ApsaraDB RDS for MySQL instance

Last Updated:Jan 17, 2024

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 databases 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

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

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

      1. Click Add Monitoring Dashboard. In the Create Monitoring Dashboard dialog box, configure the Dashboard Name parameter and click OK.

      2. Click Select Instances and Metrics, select the required nodes and metrics that you want to view, and then click the image.png icon.

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