Microsoft Azure Database for MySQL Server Monitoring
Microsoft Azure Database for MySQL Server- An Overview
Azure Database for MySQL Server offers a fully managed database service with high availability and various other built in capabilities. Applications Manager's Azure Database for MySQL Server Monitoring tool makes it easier for IT admins to maintain servers that are being used for compute-workloads as they levy a huge burden on operational costs. The major performance metrics monitored by this tool includes Server utilization, Traffic flow rate, Database statement executions, InnoDB performance, Replication status and more.
Creating a new Microsoft Azure Database for MySQL Server Monitor
To learn how to create a new Microsoft Azure Database for MySQL Server Monitor, click here.
Monitored Parameters
Navigate to the Category View by clicking the Monitors tab. Hover over 'Child Monitors' under Microsoft Azure in the Cloud Apps table, and then select the MySQL Server monitor from the displayed tooltip. This action will display the bulk configuration view for Azure Database for MySQL Server in three tabs:
- Availability tab gives the Availability history for the past 24 hours or 30 days.
- Performance tab gives the Health Status and events for the past 24 hours or 30 days.
- List view enables you to perform bulk admin configurations.
Microsoft Azure monitor provides a brief detail of the Azure Database for MySQL Server under the given subscription. Following are the list of metrics monitored in Azure Database for MySQL Server Monitoring in their corresponding tabs:
Overview
| Parameter | Description |
|---|
| SERVER INFORMATION |
| State | State of the Server |
| Fully Qualified Domain Name | The fully qualified domain name of Database for MySQL server |
| Admin Username | Username of the Central server. |
| Replication Role | The replication role of the server. |
| Resource Group Name | Name of the resource group. |
| Location | Geo location where the resource resides. |
| Version | Version of Database for MySQL server. |
| ACTIVE CONNECTIONS |
| Active Connections | The maximum number of active connections to the Database for MySQL server between the poll interval. |
| CONNECTIONS |
| Total Connections | The total number of client connections to the MySQL - Flexible Server between the poll interval. |
| Aborted Connections | The total number of failed attempts to connect to the Database for MySQL server between the poll interval. |
| NETWORK THROUGHPUT |
| Incoming Traffic | The total incoming network traffic per minute on the server between the poll interval (in MB/min). |
| Outgoing Traffic | The total outgoing network traffic per minute on the server between the poll interval (in MB/min). |
| QUERIES |
| Query Execution Rate | The total number of queries executed per minute on the server between the poll interval (in queries/min). |
| Slow Queries | The total number of slow queries on the server between the poll interval. |
| THREADS |
| Running Threads | The total number of threads that are not sleeping in the server between the poll interval. |
Usage
| Parameter | Description |
|---|
| SERVER UTILIZATION |
| CPU | The average percentage of CPU in use at the time of polling (in %). |
| Memory | The average percentage of memory in use at the time of polling (in %). |
| Storage | The average percentage of storage used out of the server's maximum at the time of polling (in %). |
| IO | The average percentage of IO in use at the time of polling (in %). |
| MEMORY |
| Available Memory | The average amount of physical memory available in the server at the time of polling (in MB). |
| CPU CREDITS |
| CPU Credits Remaining | The maximum number of CPU credits remaining on the server between the poll interval. |
| CPU Credits Consumed | The maximum number of CPU credits consumed by the server between the poll interval. |
| BACKUP STORAGE |
| Backup Storage Used | The maximum amount of backup storage used between the poll interval (in GB). |
| STORAGE |
| Storage Limit | The maximum storage that can be used for the server between the poll interval (in GB). |
| Storage Used | The maximum amount of storage in use between the poll interval (in GB). |
| SERVER LOG STORAGE |
| Server Log Storage Limit | The maximum amount of server log storage allocated for the server between the poll interval (in GB). |
| Server Log Storage Used | The maximum amount of server log storage used by the server between the poll interval (in GB). |
| Server Log Storage Percent | The maximum percentage of server log storage used out of the server's maximum server log storage between the poll interval (in %). |
| IO RATE |
| IO Rate | The total rate of i/O consumed per minute by the server between the poll interval (in operations/min). |
DDL & DML Statistics
Note: Data related to
DDL & DML Statistics in an Azure Database for MySQL Server is disabled by default and is categorized within the
Settings → Performance Polling → Optimize Data Collection section.
Refer here for the steps to enable data collection.
| Parameter | Description |
|---|
| DDL STATISTICS |
| Com Create DB | The total number of times the CREATE DB statement that has been executed between the poll interval. |
| Com Drop DB | The total number of times the DROP DB statement that has been executed between the poll interval. |
| Com Create Table | The total number of times the CREATE TABLE statement that has been executed between the poll interval. |
| Com Alter Table | The total number of times the ALTER TABLE statement that has been executed between the poll interval. |
| Com Drop Table | The total number of times the DROP TABLE statement that has been executed between the poll interval. |
| DML STATISTICS |
| Com Select | The total number of times the SELECT statement that has been executed between the poll interval. |
| Com Insert | The total number of times the INSERT statement that has been executed between the poll interval. |
| Com Update | The total number of times the UPDATE statement that has been executed between the poll interval. |
| Com Delete | The total number of times the DELETE statement that has been executed between the poll interval. |
InnoDB
Note: Data collection related to
InnoDB Statistics in an Azure Database for MySQL Server is disabled by default and is categorized within the
Settings → Performance Polling → Optimize Data Collection section.
Refer here for the steps to enable data collection.
| Parameter | Description |
|---|
| INNODB BUFFER POOL |
| InnoDB Buffer Pool Reads | The total count of logical reads that InnoDB engine couldn't satisfy from the Innodb buffer pool, and had to be fetched from the disk between the poll interval. |
| InnoDB Buffer Pool Read Requests | The total number of logical read requests to read from the Innodb buffer pool between the poll interval. |
| INNODB BUFFER POOL PAGES |
| Total Pages Containing Data | The total number of pages in the InnoDB buffer pool containing the data between the poll interval. The count includes both free and dirty pages. |
| Free Pages | The total number of free pages in the InnoDB buffer pool between the poll interval. |
| Dirty Pages | The total number of pages in the InnoDB buffer pool containing dirty pages between the poll interval. |
| INNODB DATA WRITES |
| Innodb Data Writes | The total number of data writes between the poll interval. |
| INNODB ROW LOCK TIME |
| Innodb Row Lock Time | The average time spent in acquiring row locks for InnoDB tables between the poll interval (in seconds). |
Replication
Note:- The Replica Lag and Replica IO Status group metrics are applicable only to the Replica server in Azure Database for MySQL Server monitor.
- The HA Replica Lag and HA IO Status group metrics are applicable only to the Source server in Azure Database for MySQL Server monitor.
| Parameter | Description |
|---|
| REPLICA IO STATUS |
| Replica IO Status | The state of replication I/O thread at the time of polling. Interpreted from numeric values:- 1 - Running
- 0 - Not running
|
| Replica SQL Status | The state of replication SQL thread at the time of polling. Interpreted from numeric values:- 1 - Running
- 0 - Not running
|
| REPLICA LAG |
| Replica Lag | The maximum number of seconds the replica is behind in replaying the transactions received from the source server between the poll interval (in seconds). |
| HA IO STATUS |
| HA IO Status | Indicates the state of HA replication between the poll interval. Interpreted from numeric values:- 1 - Running
- 0 - Not running
|
| HA SQL Status | Indicates the state of HA replication between the poll interval. Interpreted from numeric values:- 1 - Running
- 0 - Not running
|
| HA REPLICA LAG |
| HA Replica Lag | The maximum time lag between the primary and replica server between the poll interval (in seconds). |
Configuration
| Name | Value |
|---|
| SKU |
| SKU | The name of the deployed SKU. |
| Tier | The tier of the deployed SKU. Possible values:- Burstable
- GeneralPurpose
- MemoryOptimized
|
| STORAGE |
| IOPS | Storage IOPS for a server. |
| Auto Grow | Specifies whether the Storage Auto Grow is enabled or disabled. |
| Storage SKU | The SKU name of the server storage. |
| REPLICATION |
| Replica Capacity | Capacity of the Replica. |
| BACKUP |
| Backup Retention Period | The retention period of the backup storage. |
| Earliest Restore Date | The earliest restoring date and time of the backup storage. |
| Geo Redundant Backup | Specifies whether the Geo Redundant Backup is enabled or disabled. |
| HIGH AVAILABILITY |
| Availability Zone | Availability Zone information of the server. |
| High Availability State | Specifies the state of server high availability. Possible values:- CreatingStandby
- FailingOver
- Healthy
- NotEnabled
- RemovingStandby
|
| Mode | High availability mode for the server. Possible values:- Disabled
- SameZone
- ZoneRedundant
|
| NETWORK |
| Public Network Access | Specifies whether or not public endpoint access is allowed for this server. Possible values: Enabled/Disabled. |
| Delegated Subnet Resource ID | Delegated Subnet resource ID used to setup vnet for a server. |
| MAINTENANCE WINDOW |
| Custom Window | Specifies whether or not custom window is allowed for this server. Possible values: Enabled/Disabled. |
| Day Of Week | Day of week for maintenance window. |
| Start Hour | Start hour for maintenance window. |
| Start Minute | Start minute for maintenance window. |
