Alibaba Cloud PolarDB for MySQL Monitoring Integration
Site24x7 offers end-to-end monitoring for Alibaba Cloud PolarDB for MySQL, providing detailed insights into compute resources, memory utilization, query throughput, and session activity. Once your Alibaba Cloud account is integrated with Site24x7, all PolarDB for MySQL instances are automatically discovered and monitored.
Use cases
- Resource optimization: Track CPU, memory, and I/O usage across cluster nodes to prevent overutilization.
- Performance monitoring: Measure QPS, TPS, slow queries, and long transactions to optimize workload performance.
- Connection management: Monitor active, idle, and total connections to prevent session saturation.
- Replication and latency insights: Detect replica lag and lock contention to maintain data consistency.
- Automation and alerts: Configure thresholds and IT automation to respond to anomalies proactively.
Setup and configuration
- Log in to your Site24x7 account and navigate to Cloud > Alibaba Cloud > Add Monitor.
- In the Edit Alibaba Cloud Monitor page, select PolarDB for MySQL from the Service Types list.
- Once added, go to Cloud > Alibaba > PolarDB for MySQL to view dashboards and performance metrics.
Supported metrics
Compute & Memory
| Metric name | Description | Unit |
|---|---|---|
| Cluster CPU Utilization | The percentage of CPU utilization across the cluster. | Percentage |
| Cluster Memory Utilization | The percentage of memory used by the cluster. | Percentage |
| Total CPU Usage | Total CPU usage of the cluster. | Percentage |
| Memory Usage | Total memory usage of the cluster. | Percentage |
| Cluster PCU by CPU Cores | CPU usage per CPU core in the cluster. | Percentage |
| Cluster Proxy CPU Utilization | The CPU utilization of the cluster proxy layer. | Percentage |
Disk & I/O
| Metric name | Description | Unit |
|---|---|---|
| Cluster IOPS | The total number of I/O operations per second on the cluster. | Count/second |
| Cluster IOPS Usage | The percentage of IOPS utilization. | Percentage |
| Cluster Disk Utilization | Disk space utilization across cluster nodes. | Percentage |
| Cluster Data IOPS | IOPS specifically used for data reads/writes. | Count/second |
| Cluster Redo Write Rate | Rate of redo log writes in the cluster. | Bytes/second |
| Cluster Input Traffic | Inbound network traffic to the cluster. | Bytes/second |
| Cluster Output Traffic | Outbound network traffic from the cluster. | Bytes/second |
Connections
| Metric name | Description | Unit |
|---|---|---|
| Total Connections | Total number of connections to the cluster. | Count |
| Active Connections | The number of currently active connections. | Count |
| Idle Connections | The number of idle connections in the cluster. | Count |
| Cluster Connection Utilization | Percentage of connection utilization across the cluster. | Percentage |
| Cluster Active Sessions | The number of active sessions on cluster nodes. | Count |
Throughput & Performance
| Metric name | Description | Unit |
|---|---|---|
| Cluster TPS | Transactions processed per second in the cluster. | Count/second |
| Cluster QPS | Queries executed per second in the cluster. | Count/second |
| TPS | Transaction rate for the cluster. | Count/second |
| Cluster Memory Hit Ratio | The memory hit ratio of the cluster. | Percentage |
Latency
| Metric name | Description | Unit |
|---|---|---|
| Swell Time | Time taken by queries experiencing execution delay. | Milliseconds |
| SQLs Executing > 5s | The number of queries executing longer than 5 seconds. | Count |
| SQLs Executing > 3s | The number of queries executing longer than 3 seconds. | Count |
| SQLs Executing > 1s | The number of queries executing longer than 1 second. | Count |
MySQL Operations
| Metric name | Description | Unit |
|---|---|---|
| Cluster COM SELECT | The number of SELECT statements executed in the cluster. | Count |
| Cluster COM INSERT | The number of INSERT statements executed. | Count |
| Cluster COM INSERT SELECT | The number of INSERT INTO ... SELECT statements executed. | Count |
| Cluster COM UPDATE | The number of UPDATE statements executed. | Count |
| Cluster COM UPDATE MULTI | The number of multi-row UPDATE statements executed. | Count |
| Cluster COM DELETE | The number of DELETE statements executed. | Count |
| Cluster COM DELETE MULTI | The number of multi-row DELETE statements executed. | Count |
| Cluster COM REPLACE | The number of REPLACE statements executed. | Count |
| Cluster COM REPLACE SELECT | The number of REPLACE INTO ... SELECT statements executed. | Count |
| Cluster Slow Queries/sec | The number of slow queries per second in the cluster. | Count/second |
| Cluster InnoDB Buffer Read Hit Rate | Percentage of buffer reads served from InnoDB buffer cache. | Percentage |
| Cluster InnoDB Buffer Dirty Ratio | Percentage of dirty pages in the InnoDB buffer pool. | Percentage |
| Transactions > 5s | The number of transactions exceeding 5 seconds in execution. | Count |
| Rollback Ratio | Ratio of rolled back transactions to total transactions. | Percentage |
| Cluster Replica Lag | Replication lag between primary and replicas. | Milliseconds |
| Cluster MDL Lock Sessions | The number of sessions waiting on metadata locks. | Count |
| Cluster Other Lock Sessions | The number of sessions blocked by other locks. | Count |
Threshold configuration
- Go to Admin > Configuration Profiles > Threshold and Availability.
- Create or edit a threshold profile for PolarDB for MySQL.
- Assign the profile to the respective monitors to trigger alerts.
IT automation
Site24x7's IT Automation tools help with automatically resolving performance degradation issues. When a breach occurs, the alarm engine continuously examines the system events for which thresholds have been defined and performs the mapped automation.
- Go to Admin > IT Automation Templates.
- Create a new automation rule.
- Map the rule to the monitor for proactive resolution.
How to configure IT Automation for a monitor
Configuration rules
With Site24x7's Configuration Rules, you can set parameters like Threshold Profile, Notification Profile, Tags, and Monitor Group for multiple monitors and automate the configuration settings of your monitoring resources. Automatically assign these settings when new PolarDB for MySQL monitors are added.
How to add a Configuration Rule