The monitoring dashboard feature, provided by Database Autonomy Service (DAS), lets you select specific ApsaraDB RDS for MySQL instances and metrics to track in a single view. Use it to compare performance trends across instances and configure metric linkage to correlate anomalies at a glance.
Supported instances
This feature supports the following ApsaraDB RDS for MySQL instance types:
| MySQL version | Supported editions |
|---|---|
| 8.0 | High-availability Edition, Enterprise Edition, Cluster Edition |
| 5.7 | High-availability Edition, Enterprise Edition, Cluster Edition |
| 5.6 | High-availability Edition |
| 5.5 | High-availability Edition |
The monitoring dashboard feature has been available for ApsaraDB RDS for MySQL since May 20, 2022.
Create a monitoring dashboard
Log on to the ApsaraDB RDS console.
In the left-side navigation pane, choose Maintenance & Monitoring > Performance Monitoring.
Click the Monitoring Dashboard tab.
On the SQL Server tab, click Add Monitoring Dashboard.
Enter a Dashboard Name and click OK.
Click Select Instances and Metrics, select the RDS instances and metrics you want to track, and then click the
icon.You can select up to 32 RDS instances at a time. For descriptions of each metric, see Metrics.
Click Confirm.
To add or change the instances and metrics in an existing dashboard, click Add Instances and Metrics.
View metric trends
Log on to the ApsaraDB RDS console.
In the left-side navigation pane, choose Maintenance & Monitoring > Performance Monitoring.
Click the Monitoring Dashboard tab.
Click the tab for the database engine, select the monitoring dashboard you want to view, then set a time range to display metric trend charts for that period.
The end time must be later than the start time, and the time range cannot exceed seven days.
The following options are available on the dashboard:
| Option | Description |
|---|---|
| Instance filtering | Filter by one or more RDS instances to compare their metrics side by side. |
| Auto Refresh (Every 5 Seconds) | Automatically refresh all trend charts every 5 seconds — useful for monitoring active workloads in real time. |
| Linkage Chart | Synchronize chart cursors so you can see the values of different metrics at the same point in time, making it easier to correlate anomalies across metrics. |
| Chart Layout | Set the number of trend charts displayed per row. |
| Add Instances and Metrics | Add or change the instances and metrics shown in the dashboard. |
| Details (in a trend chart) | Expand the chart and adjust the time range for a closer look at a specific metric. |
| Delete (in a trend chart) | Remove the chart from the dashboard. |
Metrics
The following metrics are available when you configure a monitoring dashboard.
Click theicon next to any metric on the dashboard to view its description inline.
MySQL Server
| Metric | Description |
|---|---|
tps | Transactions per second (TPS) |
qps | Queries per second (QPS) |
active_session | Number of active sessions |
total_session | Total number of sessions |
delete_ps | Average number of DELETE statements executed per second |
insert_ps | Average number of INSERT statements executed per second |
replace_ps | Average number of REPLACE statements executed per second |
update_ps | Average number of UPDATE statements executed per second |
select_ps | Average number of SELECT statements executed per second |
bytes_received | Average bytes received from all clients per second |
bytes_sent | Average bytes sent to all clients per second |
iops_usage | IOPS usage |
InnoDB storage engine
| Metric | Description |
|---|---|
innodb_bp_hit | Read cache hit ratio of the InnoDB buffer pool |
innodb_bp_dirty_pct | Ratio of dirty pages in the InnoDB buffer pool |
innodb_bp_usage_pct | Utilization of the InnoDB buffer pool |
innodb_data_written | Average bytes written to InnoDB tables per second |
innodb_data_read | Average bytes read from InnoDB tables per second |
innodb_rows_deleted | Average rows deleted from InnoDB tables per second |
innodb_rows_read | Average rows read from InnoDB tables per second |
innodb_rows_inserted | Average rows inserted into InnoDB tables per second |
innodb_rows_updated | Average rows updated in InnoDB tables per second |
MySQL processes
| Metric | Description |
|---|---|
cpu_usage | CPU utilization of MySQL processes. The maximum value is 100% for ApsaraDB RDS instances. |
mem_usage | Memory usage of the ApsaraDB RDS for MySQL instance in the operating system |
iops | IOPS of the ApsaraDB RDS for MySQL instance |
disk_usage | Disk usage |