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
- The database instance that you want to monitor is provided only by one of the following types of database services: ApsaraDB RDS for MySQL, ApsaraDB for Redis, ApsaraDB for MongoDB, ApsaraDB RDS for PostgreSQL, ApsaraDB for SQL Server, or PolarDB for MySQL.
- 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:
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.
