Database Autonomy Service (DAS) allows you to globally customize monitoring dashboards. If enterprise users want to manage multiple instances, they can customize multi-instance monitoring dashboards to correlate, compare, and view multiple instances and metrics for daily O&M.

Prerequisites

Metrics

DAS monitoring dashboards monitor the following metrics. In this example, ApsaraDB RDS for MySQL is selected.

Parameter Description
tps Formula: (Com_commit + Com_rollback)/Uptime
qps Formula: Number of questions/Uptime
active_session The number of active sessions.
delete_ps The average number of DELETE statements that are executed per second.
insert_ps The average number of INSERT statements that are executed per second.
replace_ps The average number of REPLACE statements that are executed per second.
update_ps The average number of UPDATE statements that are executed per second.
select_ps The average number of SELECT statements that are executed per second.
bytes_received The average number of bytes that are received from all clients per second
bytes_sent The average number of bytes that are sent to all clients per second
innodb_bp_hit The read cache hit ratio of the InnoDB buffer pool. Formula: (Innodb_buffer_pool_read_requests - Innodb_buffer_pool_reads)/Innodb_buffer_pool_read_requests × 100%
innodb_bp_dirty_pct The dirty page ratio of the InnoDB buffer pool. Formula: Innodb_buffer_pool_pages_dirty/Innodb_buffer_pool_pages_data × 100%
innodb_bp_usage_pct The usage of the InnoDB buffer pool. Formula: Innodb_buffer_pool_pages_data/(Innodb_buffer_pool_pages_data + innodb_buffer_pool_pages_free) × 100%
innodb_data_written The average number of bytes written by InnoDB per second.
innodb_data_read The average number of bytes read by InnoDB per second.
innodb_rows_deleted The average number of rows deleted by InnoDB per second.
innodb_rows_read The average number of rows read by InnoDB per second.
innodb_rows_inserted The average number of rows inserted by InnoDB per second.
innodb_rows_updated The average number of rows updated by InnoDB per second.
Note You can view the description of each metric by clicking the icon in the console.

Add a monitoring dashboard

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Monitoring Dashboard.
  3. On the Custom Dashboard page, click a tab to select a database engine.
  4. On the tab for the specified database engine, click Add Monitoring Dashboard.
  5. In the Create Monitoring Dashboard dialog box, enter the name of the dashboard that you want to create in Dashboard Name and then click OK.
  6. Click Select Metrics and Instances. In the Select Metrics and Instances dialog box, select the instances that you want to monitor and the metrics that you want to view. Then, click .
  7. Click Confirm.
    Note To modify the instances or metrics in the monitoring dashboard, click Add Instances and Metrics in the upper-right corner.

View a monitoring dashboard

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Monitoring Dashboard.
  3. On the Custom Dashboard page, click a tab to select a database engine.
  4. On the tab for the specified database engine, select a monitoring dashboard to view and specify a time range over which you want to view the metric trend charts.
    Note When you select a time range, the end time must be later than the start time, and the interval between the start time and the end time cannot exceed seven days.
    • You can configure Filter by Instance to select multiple instances and compare their metrics.
    • If you turn on Auto Refresh, DAS refreshes metric trend charts every 5 seconds.
    • If you turn on Linkage Chart, the multi-metric linkage feature is enabled. You can view the values of different metrics at the same time point.
    • You can configure Chart Layout to specify the number of metric trend charts that can be displayed in each row.
    • You can click Add Instances and Metrics to modify instances or metrics in a monitoring dashboard.
    • You can click Details in the trend chart of a metric to zoom in the trend chart. In this case, you can modify the time to view the trend of the metric over time.
    • You can click Delete in the trend chart of a metric to delete the metric from the dashboard.