Alibaba Cloud AnalyticsDB for MySQL Monitoring Integration
Site24x7 provides comprehensive monitoring for AnalyticsDB for MySQL deployed in Alibaba Cloud. This enables you to track resource usage, identify query bottlenecks, and understand workload patterns for your real-time analytics workloads. Once your Alibaba Cloud account is integrated with Site24x7, all associated AnalyticsDB for MySQL instances are automatically discovered and monitored.
Use cases
- Query latency insights: Monitor average and max response times to pinpoint slow or overloaded queries.
- Resource tracking: Gain visibility into CPU, I/O, and disk usage across workers and executors to prevent contention.
- Insert performance tuning: Monitor data ingestion rates and insert latencies to improve write efficiency.
- Workload optimization: Analyze resubmitted and short queries to improve workload management.
- Failure monitoring: Detect and react to query failure trends early to ensure application reliability.
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 AnalyticsDB for MySQL from the Service Types list.
- Once added, go to Cloud > Alibaba > AnalyticsDB for MySQL to view dashboards and performance metrics.
Supported metrics
Executor and Worker CPU / IO
| Metric name | Description | Unit |
|---|---|---|
| Executor Average CPU Used | The average CPU usage of the executor node. | Percentage |
| Executor Maximum CPU Used | The peak CPU usage observed on the executor. | Percentage |
| Worker Average CPU Used | The average CPU usage of the worker node. | Percentage |
| Worker Maximum CPU Used | The peak CPU usage on the worker node. | Percentage |
| Worker Average I/O Utilization | The average I/O utilization of the worker node. | Percentage |
| Executor Average Write IOPS | The average number of write operations per second on executor. | IOPS |
| Executor Average Read IOPS | The average number of read operations per second on executor. | IOPS |
| Worker Average Write IOPS | The average number of write operations per second on worker. | IOPS |
| Worker Average Read IOPS | The average number of read operations per second on worker. | IOPS |
Disk and Storage Usage
| Metric name | Description | Unit |
|---|---|---|
| Disk Used (MB) | The total disk space used. | MB |
| Disk Used Percentage | The percentage of total disk usage. | Percentage |
| Cold Data Disk Usage | Disk space used for cold data storage. | MB |
| Hot Data Disk Usage | Disk space used for hot data storage. | MB |
| Worker Maximum Node Disk Used | Maximum disk usage percentage across all worker nodes. | Percentage |
Query Performance and Latency
| Metric name | Description | Unit |
|---|---|---|
| Query Average Response Time | The average response time of queries. | Milliseconds |
| Query Maximum Response Time | The maximum response time observed among queries. | Milliseconds |
| Query Total Wait Time | The total wait time of all queries. | Milliseconds |
| Query Failed Ratio | The ratio of failed queries to total queries. | Percentage |
| Queries Per Second (QPS) | The number of queries processed per second. | Count/second |
| Transactions Per Second (TPS) | The number of transactions processed per second. | Count/second |
| APS Average Latency | The average latency of APS queries. | Milliseconds |
| APS Maximum Latency | The maximum latency of APS queries. | Milliseconds |
| APS Average Latency by Job | The average latency of APS queries grouped by job. | Milliseconds |
| APS Maximum Latency by Job | The maximum latency of APS queries grouped by job. | Milliseconds |
Insert Performance
| Metric name | Description | Unit |
|---|---|---|
| Insert Incoming Bytes | The volume of data inserted into the database. | Bytes |
| Insert Maximum Response Time | The maximum time taken for insert operations. | Milliseconds |
| Insert Average Response Time | The average time taken for insert operations. | Milliseconds |
WLM (Workload Management) and Failures
| Metric name | Description | Unit |
|---|---|---|
| WLM SQA Queries Count | The number of short query acceleration (SQA) queries executed. | Count |
| WLM Resubmitted Queries Count | The number of queries that were resubmitted after failure. | Count |
Threshold configuration
- Go to Admin > Configuration Profiles > Threshold and Availability.
- Create or edit a threshold profile for AnalyticsDB 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 AnalyticsDB for MySQL monitors are added.
How to add a Configuration Rule