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 operations and maintenance.

Prerequisites

Monitoring metrics

DAS monitoring dashboards support the following metrics. MySQL is used in this example.

You can view the description of each metric by clicking the icon in the console.

tps Formula: (Com_commit + Com_rollback)/Uptime
qps Formula: Questions/Uptime
active_session The active sessions
delete_ps The average number of DELETE statements executed per second
insert_ps The average number of INSERT statements executed per second
replace_ps The average number of REPLACE statements executed per second
update_ps The average number of UPDATE statements executed per second
select_ps The average number of SELECT statements executed per second
bytes_received The average number of bytes received from all clients per second
bytes_sent The average number of bytes sent to all clients per second
innodb_bp_hit The read hit rate 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

Procedure

  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 specified database engine tab, click Add Monitoring Dashboard.
  5. Enter a dashboard name and then click Ok.
  6. Click Add Instances and Metrics.
  7. Select the instances and metrics and then click the icon.
  8. Click Confirm.
  9. To modify the monitoring dashboard, click Add Instances and Metrics in the upper-right corner to modify the instances or metrics.