Alibaba Cloud RDS for MySQL Monitoring Integration
Site24x7 offers comprehensive monitoring for Alibaba Cloud RDS for MySQL, providing deep insights into database performance, connection utilization, disk activity, and replication health. When you integrate your Alibaba Cloud account with Site24x7, all RDS for MySQL instances are automatically discovered and monitored.
Use cases
- Performance tuning: Monitor CPU load, active threads, and query execution rates to identify and optimize bottlenecks.
- Replication management: Detect replication lag and synchronization delays between standby and primary instances.
- Storage visibility: Track disk usage trends and identify space consumed by logs, temporary files, and data tables.
- InnoDB optimization: Analyze buffer pool efficiency and row operations to fine-tune database caching.
- Automation and alerts: Create threshold-based alerts and automate recovery to prevent downtime.
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 RDS for MySQL from the Service Types list.
- Once added, go to Cloud > Alibaba > RDS for MySQL to view dashboards and performance metrics.
Supported metrics
CPU & Thread
| Metric name | Description | Unit |
|---|---|---|
| MySQL Proxy CPU Utilization | The percentage of CPU utilization by the MySQL proxy layer. | Percentage |
| MySQL Threads Running | The number of threads actively running queries. | Count |
| MySQL Threads Connected | The total number of currently connected threads. | Count |
Session
| Metric name | Description | Unit |
|---|---|---|
| MySQL Total Sessions | The total number of database sessions (active and idle). | Count |
| MySQL Active Sessions | The number of currently active database sessions. | Count |
| MySQL MDL Lock Sessions | The number of sessions currently waiting for metadata locks. | Count |
Disk & Storage
| Metric name | Description | Unit |
|---|---|---|
| MySQL Temp Disk Size | The total size of temporary disk space used by MySQL operations. | Bytes |
| MySQL Temp File Size | The size of temporary files generated during query execution. | Bytes |
| MySQL User Data Size | The total disk space used by user data. | Bytes |
| MySQL System Data Size | The disk space occupied by system data. | Bytes |
| MySQL Other Disk Size | The disk space used by non-data files (logs, caches, etc.). | Bytes |
| MySQL Log Disk Size | The total size of binary, redo, and slow logs stored on disk. | Bytes |
| MySQL Instance Disk Size | The total storage size consumed by the MySQL instance. | Bytes |
I/O & File
| Metric name | Description | Unit |
|---|---|---|
| MySQL Open Files | The number of currently open files by the MySQL instance. | Count |
| MySQL InnoDB Open Files | The number of open files handled by the InnoDB storage engine. | Count |
| MySQL InnoDB Log Writes | The total number of log write operations performed by InnoDB. | Count |
| MySQL InnoDB Log Write Requests | The total number of write requests issued to the InnoDB log. | Count |
| MySQL InnoDB Log Fsync | The number of fsync operations performed on InnoDB logs. | Count |
| MySQL Data IO Bytes/sec | The total I/O throughput (read + write) of the database per second. | Bytes/second |
InnoDB Row & Buffer
| Metric name | Description | Unit |
|---|---|---|
| MySQL InnoDB Row Inserts | The number of rows inserted into InnoDB tables. | Count |
| MySQL InnoDB Row Updates | The number of rows updated in InnoDB tables. | Count |
| MySQL InnoDB Row Deletes | The number of rows deleted from InnoDB tables. | Count |
| MySQL InnoDB Data Reads | The total amount of data read by InnoDB. | Bytes |
| MySQL InnoDB Row Lock Time/sec | The average row lock wait time per second in InnoDB. | Milliseconds |
| MySQL InnoDB Ibuf Usage Ratio | The percentage of buffer pool pages currently in use. | Percentage |
| MySQL InnoDB Ibuf Dirty Ratio | The percentage of dirty pages in the InnoDB buffer pool. | Percentage |
| MySQL InnoDB Ibuf Read Hits | The read hit ratio of the InnoDB buffer pool. | Percentage |
| MySQL InnoDB Ibuf Pool Reads | The total number of reads from the InnoDB buffer pool. | Count |
Log & Binlog
| Metric name | Description | Unit |
|---|---|---|
| MySQL Relay Log Size | The total size of relay logs used for replication. | Bytes |
| MySQL Binlog Size | The total size of binary logs generated by the MySQL server. | Bytes |
| MySQL Redo Log Size | The total size of redo logs used by InnoDB. | Bytes |
| MySQL General Log Size | The size of the general query log file. | Bytes |
| MySQL Slow Log Size | The size of the slow query log file. | Bytes |
| MySQL Undo Log Size | The total size of undo logs used for transaction rollback. | Bytes |
SQL & Command Execution
| Metric name | Description | Unit |
|---|---|---|
| MySQL COM SELECT | The number of SELECT statements executed. | Count |
| MySQL SELECT Scan | The number of full table scans performed by SELECT queries. | Count |
| MySQL COM UPDATE | The number of UPDATE statements executed. | Count |
| MySQL COM DELETE | The number of DELETE statements executed. | Count |
| MySQL COM INSERT | The number of INSERT statements executed. | Count |
| MySQL COM INSERT SELECT | The number of INSERT INTO ... SELECT statements executed. | Count |
| MySQL COM REPLACE | The number of REPLACE statements executed. | Count |
| MySQL COM REPLACE SELECT | The number of REPLACE INTO ... SELECT statements executed. | Count |
Performance & Rate
| Metric name | Description | Unit |
|---|---|---|
| MySQL QPS | The number of queries executed per second. | Count/second |
| MySQL TPS | The number of transactions processed per second. | Count/second |
| MySQL Insert Size | The total size of data inserted during queries. | Bytes |
Replication
| Metric name | Description | Unit |
|---|---|---|
| MySQL Network In | The amount of inbound network traffic received by the MySQL instance. | Bytes/second |
| MySQL Network Out | The amount of outbound network traffic sent by the MySQL instance. | Bytes/second |
| MySQL Standby Sync Lag | The synchronization delay between primary and standby MySQL instances. | Milliseconds |
| MySQL Slave IO Running | The status of the replication I/O thread (1 for running, 0 for stopped). | Status |
| MySQL Slave SQL Running | The status of the replication SQL thread (1 for running, 0 for stopped). | Status |
Threshold configuration
- Go to Admin > Configuration Profiles > Threshold and Availability.
- Create or edit a threshold profile for RDS 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 RDS for MySQL monitors are added.
How to add a Configuration Rule