Use a monitor to monitor key performance metrics
Select a database on the MySQL Database on Azure management interface and select the Monitor window to monitor key performance metrics for this database in real time.
Click on Add alert to add alert rules as required. The system currently supports the following metrics:
Performance metric | Description |
---|---|
Com_delete | The number of delete queries |
Com_insert | The number of insert queries |
Com_replace | The number of replace queries |
Com_select | The number of select queries |
Com_update | The number of update queries |
Failed Connection | The number of failed connections |
CPU Utilization | Average CPU usage |
Network Out | Outgoing data traffic |
Network In | Incoming data traffic |
Queries | The number of queries |
Replication Lag In Second | Replication lag (second) |
Replication Queries | Replication queries |
Replication Transaction | Replication items |
Slow Queries | The number of slow queries |
Storage | Storage space used |
Successful Connections | The number of successful connections |
Concurrent Connections | The number of concurrent connections |
Throttled Connections | The number of throttled connections |
You can select a time range of 5, 10, 15, 30, or 45 minutes, and 1, 2, 3, 4, 5, or 6 hours. If a particular metric complies with the preset conditions and thresholds, MySQL Database on Azure will send an email to the administrator or route the alert to the Webhook that you set up.