Advanced monitoring
Updated at:
Copy as MD
Advanced monitoring provides deeper visibility into your PolarDB for MySQL cluster than standard performance monitoring. It supports a broader set of performance metrics, custom dashboards, and automatic event detection — with root cause analysis and actionable suggestions delivered as events occur. For issues that require manual investigation, select a specific time range and trigger an on-demand diagnosis.
View advanced monitoring data
Prerequisites
Before you begin, ensure that you have:
-
A running PolarDB for MySQL cluster
Open advanced monitoring
-
Log on to the PolarDB console.
-
In the upper-left corner, select the region where the cluster is deployed.
-
Find the cluster and click its ID.
-
In the left-side navigation pane, choose .
-
Click the Advanced Monitoring tab.
Use Standard View
On the Standard View tab, select a node to view its performance trend charts for the last one hour, last one day, or last seven days.
The following actions are available in Standard View:
| Action | Description |
|---|---|
| More Metrics | View performance trends for additional metrics. |
| Add Trend Comparison | Compare performance trends for a metric across different time ranges. |
| Diagnose | Select a time range in a monitoring item's trend chart, then click Diagnose to analyze metrics in that range. |
| Details | Expand a monitoring item's trend chart. Adjust the time range to see how the metric changes over a specific period. |
Use Custom View
On the Custom View tab, create and manage multiple performance monitoring dashboards tailored to your business needs. Displaying multiple metrics in the same chart makes it easier to correlate data during troubleshooting and analysis.
The first time you use Custom View, you must create dashboards first. For more information, see Monitoring dashboards.
Performance metrics
Advanced monitoring tracks the following performance metrics. To view details about a metric, click 
to the right of the metric name.
| Category | Metric | Description |
|---|---|---|
| CPU utilization/Memory usage | polardbmysql.mem_usage | Memory usage as a percentage of total operating system memory. Unit: percentage. |
| polardbmysql.cpu_usage | CPU utilization of the service process. A value of 200% means 2 CPU cores are in use. Unit: percentage. | |
| TPS/QPS | polardbmysql.mps | Number of operations per second. |
| polardbmysql.tps | Transactions per second (TPS). Formula: (Com_commit + Com_rollback) / Uptime | |
| polardbmysql.qps | Queries per second (QPS). Formula: Queries / Uptime | |
| Sessions | polardbmysql.active_session | Number of active sessions. |
| polardbmysql.total_session | Total number of sessions. | |
| Traffic throughput | polardbmysql.output_traffic | Average bytes sent to all clients per second. Unit: KB/s. |
| polardbmysql.input_traffic | Average bytes received from all clients per second. Unit: KB/s. | |
| Temporary table | polardbmysql.created_tmp_disk_tables | Number of temporary tables created per second. |
| Executions | polardbmysql.com_replace | Average REPLACE statements executed per second. |
| polardbmysql.com_delete_multi | Average MULTI_DELETE statements executed per second. | |
| polardbmysql.com_update_multi | Average MULTI_UPDATE statements executed per second. | |
| polardbmysql.com_insert_select | Average INSERT_SELECT statements executed per second. | |
| polardbmysql.com_delete | Average DELETE statements executed per second. | |
| polardbmysql.com_select | Average SELECT statements executed per second. | |
| polardbmysql.com_insert | Average INSERT statements executed per second. | |
| polardbmysql.com_replace_select | Average REPLACE_SELECT statements executed per second. | |
| polardbmysql.com_update | Average UPDATE statements executed per second. | |
| Replication latency | Replica_lag_ms | Replication latency. Unit: milliseconds. |
| Blocked connections | polardbmysql.mdl_lock_session | Number of connections blocked by the MDL lock. |
| polardbmysql.other_lock_session | Number of connections blocked by other locks. | |
| InnoDB read/write throughput | polardbmysql.innodb_data_read | Average bytes read from InnoDB tables per second. Unit: KB/s. |
| polardbmysql.innodb_data_written | Average bytes written to InnoDB tables per second. Unit: KB/s. | |
| InnoDB buffer pool requests | polardbmysql.innodb_buffer_pool_read_requests | Average logical page reads from the InnoDB buffer pool per second. |
| polardbmysql.innodb_buffer_pool_write_requests | Average page writes to the InnoDB buffer pool per second. | |
| InnoDB buffer pool hit ratio | polardbmysql.innodb_buffer_use_ratio | InnoDB buffer pool usage. Unit: percentage. Formula: innodb_buffer_pool_pages_data / (innodb_buffer_pool_pages_data + innodb_buffer_pool_pages_free) × 100% |
| polardbmysql.innodb_buffer_dirty_ratio | Ratio of dirty pages in the InnoDB buffer pool. Unit: percentage. Formula: Innodb_buffer_pool_pages_dirty / Innodb_buffer_pool_pages_data × 100% | |
| polardbmysql.innodb_buffer_read_hit | Read hit ratio of the InnoDB buffer pool. Unit: percentage. Formula: (Innodb_buffer_pool_read_requests - Innodb_buffer_pool_reads) / Innodb_buffer_pool_read_requests × 100% | |
| InnoDB redo writes | polardbmysql.innodb_log_write_requests | Physical writes to logs per second. |
| polardbmysql.innodb_os_log_fsyncs | Synchronizations per second. | |
| InnoDB row operations | polardbmysql.innodb_rows_read | Average rows read from InnoDB tables per second. |
| polardbmysql.innodb_rows_updated | Average rows updated in InnoDB tables per second. | |
| polardbmysql.innodb_rows_inserted | Average rows inserted into InnoDB tables per second. | |
| polardbmysql.innodb_rows_deleted | Average rows deleted from InnoDB tables per second. | |
| Storage space used | polardbmysql.redolog_size | Storage used by redo logs. Unit: MB. |
| polardbmysql.sys_dir_size | Storage used by the system. Unit: MB. | |
| polardbmysql.data_size | Storage used by data. Unit: MB. | |
| polardbmysql.other_log_size | Storage used by other logs. Unit: MB. | |
| polardbmysql.undolog_size | Storage used by undo logs. Unit: MB. | |
| polardbmysql.binlog_size | Storage used by binary logs. Unit: MB. | |
| polardbmysql.log_size | Storage used by logs. Unit: MB. | |
| polardbmysql.tmp_dir_size | Storage used by temporary files. Unit: MB. | |
| IOPS | polardbmysql.iops_r | Read IOPS. Unit: counts/s. |
| polardbmysql.io_throughput | Total I/O throughput. Unit: MB. | |
| polardbmysql.io_throughput_r | Read I/O throughput. Unit: MB. | |
| polardbmysql.io_throughput_w | Write I/O throughput. Unit: MB. | |
| polardbmysql.iops_w | Write IOPS. Unit: counts/s. | |
| polardbmysql.iops | Total IOPS. Unit: counts/s. | |
| Com_stmt status | Com_stmt_execute | Total COM_STMT_EXECUTE statements executed. |
| Com_stmt_reprepare | Total COM_STMT_REPREPARE statements executed. | |
| Com_stmt_send_long_data | Total COM_STMT_SEND_LONG_DATA statements executed. | |
| Com_stmt_reset | Total COM_STMT_RESET statements executed. | |
| Com_stmt_prepare | Total COM_STMT_PREPARE statements executed. | |
| Prepared_stmt_count | Current number of prepared statements. | |
| Com_stmt_close | Total COM_STMT_CLOSE statements executed. | |
| Historical transaction list length | innodb_trx_history_list_len | Length of the historical transaction list. |
Is this page helpful?