How to monitor Relational Database MySQL in Huawei Cloud
Site24x7 continuously monitors Huawei Cloud's Relational Database (RDS) MySQL environments with insights into CPU, memory, disk I/O, network throughput, connections, and query performance that helps to detect bottlenecks early and ensure reliable database operations.
Use cases
Connection stability: To prevent connection failures, monitor the total number of connections and usage. This allows for adjustments or scaling before reaching capacity limits.
Memory efficiency: Minimize I/O latency by keeping an eye on buffer pool metrics. This helps ensure that data remains in memory and decreases reliance on disk storage.
Query optimization: Reduce latency by tracking slow queries and overall throughput. This makes it possible to identify inefficient SQL queries early, preventing negative impacts on users.
Setup and configuration
RDS MySQL resources are auto-discovered and monitored during the Huawei Cloud integration. To enable monitoring, follow the steps below:
- Navigate to Cloud > Huawei > Add Huawei Monitor. Follow the steps to add a Huawei Cloud monitor.
- While adding or editing a Huawei Cloud monitor, select RDS MySQL from the Service/Resource Types drop-down and click Save.
- Navigate to Cloud > Huawei, select the created Huawei monitor, and then click RDS MySQL to view the performance metrics.
Supported metrics
CPU and memory
Metric name | Description | Units |
| CPU Utilization | The percentage of CPU capacity currently consumed by the RDS MySQL instance. | Percentage |
| Memory Utilization | The percentage of memory capacity currently consumed by the RDS MySQL instance. | Percentage |
Network
Metric name | Description | Units |
| Network Input Throughput | The rate of data received by the instance over the network per second. | Bytes/second |
| Network Output Throughput | The rate of data transmitted out of the instance over the network per second. | Bytes/second |
Connections
Metric name | Description | Units |
| Total Connections | The total number of connections currently established to the MySQL instance. | Count |
| Active Connections | The number of connections currently executing a query or operation. | Count |
| Connection Usage | The percentage of available connection capacity currently in use. | Percentage |
Queries and transactions
Metric name | Description | Units |
| Queries Per Second | The rate of query statements executed on the instance per second. | Count/second |
| Transactions Per Second | The rate of transactions committed on the instance per second. | Count/second |
| Slow Queries | The number of queries that exceeded the configured slow query threshold. | Count |
DML Operations
Metric name | Description | Units |
| Delete Statements | The rate of DELETE statements executed on the instance per second. | Count/second |
| Insert Statements | The rate of INSERT statements executed on the instance per second. | Count/second |
| Select Statements | The rate of SELECT statements executed on the instance per second. | Count/second |
| Update Statements | The rate of UPDATE statements executed on the instance per second. | Count/second |
InnoDB
Metric name | Description | Units |
| InnoDB Buffer Pool Utilization | The percentage of the InnoDB buffer pool currently in use. | Percentage |
| InnoDB Buffer Pool Hit Rate | The percentage of read requests served from the InnoDB buffer pool without disk access. | Percentage |
| InnoDB Buffer Pool Dirty Page Rate | The percentage of InnoDB buffer pool pages that are dirty and pending a flush to disk. | Percentage |
| InnoDB Read Throughput | The rate of data read by the InnoDB storage engine per second. | Bytes/second |
| InnoDB Write Throughput | The rate of data written by the InnoDB storage engine per second. | Bytes/second |
| InnoDB Read Operations | The number of InnoDB read I/O operations performed per second. | Count/second |
| InnoDB Write Operations | The number of InnoDB write I/O operations performed per second. | Count/second |
Disk and I/O
Metric name | Description | Units |
| IOPS | The number of read and write I/O operations processed by the disk per second. | Count/second |
| Disk Utilization | The percentage of total disk storage currently consumed by the instance. | Percentage |
| Disk Total Size | The total disk storage capacity provisioned for the instance. | GB |
| Disk Used Size | The total disk storage currently consumed by the instance. | GB |
| Disk Read Throughput | The rate of data read from disk per second. | Bytes/second |
| Disk Write Throughput | The rate of data written to disk per second. | Bytes/second |
| VM I/O Utilization | The percentage of VM-level I/O capacity currently in use. | Percentage |
Threshold configuration
You can configure thresholds and alerts for all RDS MySQL metrics to detect performance degradation proactively or connection issues.
- Go to Admin > Configuration Profiles > Threshold and Availability.
- Create or edit your Threshold Profile for RDS MySQL.
- Assign the profile to the respective monitors to trigger alerts.
IT Automation
Use Site24x7's IT Automation to resolve common issues with RDS MySQL performance:
- Go to Admin > IT Automation Templates. Then, click Add Automation Templates.
- Create an automation rule by selecting the automation Type (e.g., Server reboot, clear queue).
- Map the created rules to the RDS MySQL, for automatic execution during alerts.
Configuration rules
Use Configuration Rules to simplify bulk setup across RDS MySQL instances. Automatically assign Threshold Profiles, Notification Profiles, Tags, and Monitor Groups when new monitors are discovered.