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.
- A database instance that runs MySQL, MongoDB, Redis, or PolarDB for MySQL is used.
- The database instance is connected to DAS and is in the Accessed state. For more information about how to connect a database instance to DAS, see the following topics:
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|
|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|
- Log on to the DAS console.
- In the left-side navigation pane, click Monitoring Dashboard.
- On the Custom Dashboard page, click a tab to select a database engine.
- On the specified database engine tab, click Add Monitoring Dashboard.
- Enter a dashboard name and then click Ok.
- Click Add Instances and Metrics.
- Select the instances and metrics and then click the icon.
- Click Confirm.
- To modify the monitoring dashboard, click Add Instances and Metrics in the upper-right corner to modify the instances or metrics.