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.
- The database instance to be monitored is provided by MySQL, Redis, MongoDB, PostgreSQL, SQL Server, or the ApsaraDB PolarDB MySQL-compatible edition.
- The database instance that you want to manage 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. In this example, MySQL is selected.
|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 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 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.|
- 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 tab for the specified database engine, click Add Monitoring Dashboard.
- In the Create Monitoring Dashboard dialog box, configure Dashboard Name and click OK.
- Click Add Instances and Metrics. 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 .
- Click Confirm. Note To modify the instances or metrics in the monitoring dashboard, click Add Instances and Metrics in the upper-right corner.