PolarDB-X is integrated with the performance trend feature that is provided by Data Autonomy Service (DAS). You can use this feature to view the details of each performance metric of compute nodes, data nodes, Global Meta Service (GMS) nodes, and change data capture (CDC) nodes of your PolarDB-X instance. You can use multiple methods to view the performance trends of your PolarDB-X instance. You can specify a time range to view the performance metrics that are collected in the specified period of time. You can specify two dates to view the comparison between the performance metrics that are collected on the specified days. You can also use custom dashboards to display the performance metrics that you want to view.
View performance trends
Log on to the PolarDB-X console.
On the Instances page, click the PolarDB-X 2.0 tab.
In the top navigation bar, select the region of the instance.
Find the instance that you want to manage and click the instance name.
In the left-side navigation pane, choose .
On the page that appears, you can click the Compute Node (CN), Data Node (DN), GMS Node, and Log Node (CDC) tab to view the performance metrics. For more information about the metrics, see Metric description.
NoteOnly the Data Node (DN) tab is available for a PolarDB-X Standard Edition instance.
The Node list displays the specifications, CPU utilization, memory usage, and current active connections for each node.
Click the Performance Trends tab, specify a node and a time range, and then click Search to view performance monitoring data in each chart.
You can click More Metrics to select the metrics whose performance trend that you want to view.
In a performance trend chart, drag and drop the pointer to specify a time range and click Diagnose to check whether the metric is normal within the selected time range. For more information, see Diagnose node performance.
You can click Details in the upper-right corner of the trend chart of a metric to zoom in the trend chart. In this case, you can modify the time to view the trend of the metric over time.
Click the Performance Trend Comparison tab. Specify a node, two dates, and a time range, and then click Search to view the comparison between the performance metrics that are collected on the specified days.
On the Custom Chart tab, you can create multiple monitoring dashboards as needed to display the performance metrics that you want to view within a single chart. This helps efficiently troubleshoot and analyze issues.
NoteThe first time your use the feature, you must create monitoring dashboards.
Diagnose node performance
PolarDB-X provides the performance diagnostics feature. In a performance trend chart of a node, select a time range to diagnose the performance of the node based on resource usage and slow SQL queries.
Compute nodes and data nodes support the performance diagnostics feature. GMS nodes and CDC nodes do not support this feature.
Log on to the PolarDB-X console.
In the left-side navigation pane, click Instance List. On the Instance List page, click the PolarDB-X 2.0 tab.
In the top navigation bar, select the region in which your instance resides.
Find the instance that you want to manage and click the instance ID.
In the left-side navigation pane, choose .
In a performance trend chart, hold and drag the mouse to select a time range and click Diagnose.
On the Details page that appears, view the statistical information about resource usage and slow SQL queries.
Metric description
Compute nodes
Metric | Unit | Description |
polardbx.cpu_usage | % | The average CPU utilization within the specified period of time. |
polardbx.mem_usage | % | The memory usage of the Java Virtual Machine (JVM). In specific scenarios, the memory usage fluctuates. |
polardbx.active_connection | Count | The total number of connections. |
polardbx.running_thread | Count | The number of active connections. |
polardbx.network_in_bytes | byte | The total amount of inbound traffic. |
polardbx.network_out_bytes | byte | The total amount of outbound traffic. |
polardbx.logic_qps | Per Second | The total number of logical SQL query statements that are executed per second. Logical SQL query statements are SQL statements that are sent from your business application to your PolarDB-X database. |
polardbx.physical_qps | Per Second | The total number of physical SQL query statements that are executed per second. Physical SQL query statements are executed on the read-only nodes of your database. |
polardbx.logic_rt | Milliseconds | The average response time of logical SQL queries. |
polardbx.physical_rt | Milliseconds | The average response time of physical SQL queries. |
polardbx.slow_request_count | Per Second | The number of slow logical SQL queries. |
polardbx.physical_slow_request_count | Per Second | The number of slow physical SQL queries. |
Data nodes and GMS nodes
Metric | Unit | Description |
mysql.tps | Per Second | The number of transactions that are run on the data node per second. |
mysql.qps | Per Second | The number of queries that are run on the data node per second. |
mysql.total_session | Count | The total number of sessions. |
mysql.active_session | Count | The number of active sessions. |
mysql.bytes_received | KB | The average number of bytes in the data that the node receives from all clients per second. |
mysql.bytes_sent | KB | The average number of bytes in the data that is sent from the node to all clients per second. |
mysql.tb.tmp.disk | Count | The number of temporary tables that are automatically created on the disk of the node when SQL statements are executed. |
mysql.insert_ps | Per Second | The average number of INSERT statements that are executed per second. |
mysql.select_ps | Per Second | The average number of SELECT statements that are executed per second. |
mysql.update_ps | Per Second | The average number of UPDATE statements that are executed per second. |
mysql.delete_ps | Per Second | The average number of DELETE statements that are executed per second. |
mysql.replace_ps | Per Second | The average number of REPLACE statements that are executed per second. |
mysql.innodb_data_written | KB | The average number of bytes in the data that is written to InnoDB per second. |
mysql.innodb_data_read | KB | The average number of bytes in the data that is read from InnoDB per second. |
mysql.innodb_buffer_pool_reads_requests | Count | The average number of logical reads that read data pages from the InnoDB buffer pool per second. |
mysql.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% |
mysql.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% |
mysql.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% |
mysql.innodb_log_writes | Per Second | The average number of physical writes to the InnoDB redo log file per second. |
mysql.innodb_os_log_fsyncs | Per Second | The average number of fsync() writes to the log file per second. |
mysql.innodb_rows_deleted | Per Second | The average number of InnoDB rows from which data is deleted per second. |
mysql.innodb_rows_read | Per Second | The average number of InnoDB rows from which data is read per second. |
mysql.innodb_rows_inserted | Per Second | The average number of InnoDB rows into which data is inserted per second. |
mysql.innodb_rows_updated | Per Second | The average number of InnoDB rows in which data is updated per second. |
mysql.mem_usage | % | The memory usage of the MySQL instance in the entire operating system. |
mysql.cpu_usage | % | The CPU utilization of MySQL processes. This metric can reach up to 100% for Alibaba Cloud database instances. |
mysql.data.size | MB | The size of the data space. |
mysql.tmp.size | MB | The size of the temporary tablespace. |
mysql.other.size | MB | The system space. |
mysql.instance.size | MB | The total used space of the MySQL database instance. |
mysql.log.size | MB | The size of the log space. |
mysql.iops | Count | The IOPS of the MySQL instance. |
CDC nodes
Metric | Unit | Description |
polardbx_cdc.cpu_usage | % | The CPU utilization. |
polardbx_cdc.mem_usage | % | The memory usage. |
polardbx_cdc.dumper_heapUsage | % | The heap memory usage. |
polardbx_cdc.dumper_delay | Milliseconds | The latency for processing binary log events. |