Supported metrics for Microsoft.DBforMySQL/flexibleServers

The following table lists the metrics available for the Microsoft.DBforMySQL/flexibleServers resource type.

Table headings

Metric - The metric display name as it appears in the Azure portal.
Name in Rest API - Metric name as referred to in the REST API.
Unit - Unit of measure.
Aggregation - The default aggregation type. Valid values: Average, Minimum, Maximum, Total, Count.
Dimensions - Dimensions available for the metric.
Time Grains - Intervals at which the metric is sampled. For example, PT1M indicates that the metric is sampled every minute, PT30M every 30 minutes, PT1H every hour, and so on.
DS Export- Whether the metric is exportable to Azure Monitor Logs via Diagnostic Settings.

For information on exporting metrics, see Create diagnostic settings in Azure Monitor.

For information on metric retention, see Azure Monitor Metrics overview.

For a list of supported logs, see Supported log categories - Microsoft.DBforMySQL/flexibleServers

Category Metric Name in REST API Unit Aggregation Dimensions Time Grains DS Export
Errors Aborted Connections

Aborted Connections
aborted_connections Count Total (Sum) <none> PT1M Yes
Traffic Active Connections

Active Connections
active_connections Count Average, Maximum, Minimum <none> PT1M Yes
Traffic Active Transactions

Number of active transactions.
active_transactions Count Total (Sum), Average, Maximum, Minimum <none> PT1M Yes
Saturation Backup Storage Used

Backup Storage Used
backup_storage_used Bytes Average, Maximum, Minimum <none> PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Binlog Storage Used

Storage used by Binlog files.
binlog_storage_used Bytes Average, Maximum, Minimum <none> PT1M Yes
Traffic Com Alter Table

The number of times ALTER TABLE statement has been executed.
Com_alter_table Count Total (Sum) <none> PT1M Yes
Traffic Com Create DB

The number of times CREATE DB statement has been executed.
Com_create_db Count Total (Sum) <none> PT1M Yes
Traffic Com Create Table

The number of times CREATE TABLE statement has been executed.
Com_create_table Count Total (Sum) <none> PT1M Yes
Traffic Com Delete

The number of times DELETE statement has been executed.
Com_delete Count Total (Sum) <none> PT1M Yes
Traffic Com Drop DB

The number of times DROP DB statement has been executed.
Com_drop_db Count Total (Sum) <none> PT1M Yes
Traffic Com Drop Table

The number of times DROP TABLE statement has been executed.
Com_drop_table Count Total (Sum) <none> PT1M Yes
Traffic Com Insert

The number of times INSERT statement has been executed.
Com_insert Count Total (Sum) <none> PT1M Yes
Traffic Com Select

The number of times SELECT statement has been executed.
Com_select Count Total (Sum) <none> PT1M Yes
Traffic Com Update

The number of times UPDATE statement has been executed.
Com_update Count Total (Sum) <none> PT1M Yes
Saturation CPU Credits Consumed

CPU Credits Consumed
cpu_credits_consumed Count Average, Maximum, Minimum <none> PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation CPU Credits Remaining

CPU Credits Remaining
cpu_credits_remaining Count Average, Maximum, Minimum <none> PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Host CPU Percent

Host CPU Percent
cpu_percent Percent Average, Maximum, Minimum <none> PT1M Yes
Saturation Data Storage Used

Storage used by data files.
data_storage_used Bytes Average, Maximum, Minimum <none> PT1M Yes
Availability HA IO Status

Status for replication IO thread running
HA_IO_status Count Maximum <none> PT1M Yes
Latency HA Replication Lag

HA Replication lag in seconds
HA_replication_lag Seconds Average, Maximum, Minimum <none> PT1M Yes
Availability HA SQL Status

Status for replication SQL thread running
HA_SQL_status Count Maximum <none> PT1M Yes
Saturation Ibdata1 Storage Used

Storage used by ibdata1 files.
ibdata1_storage_used Bytes Average, Maximum, Minimum <none> PT1M Yes
Saturation InnoDB Buffer Pool Pages Data

The number of pages in the InnoDB buffer pool containing data.
Innodb_buffer_pool_pages_data Count Total (Sum), Maximum, Minimum <none> PT1M Yes
Saturation InnoDB Buffer Pool Pages Dirty

The current number of dirty pages in the InnoDB buffer pool.
Innodb_buffer_pool_pages_dirty Count Total (Sum), Maximum, Minimum <none> PT1M Yes
Traffic Innodb Buffer Pool Pages Flushed

The number of requests to flush pages from the InnoDB buffer pool.
Innodb_buffer_pool_pages_flushed Count Average, Maximum, Minimum <none> PT1M Yes
Saturation InnoDB Buffer Pool Pages Free

The number of free pages in the InnoDB buffer pool.
Innodb_buffer_pool_pages_free Count Total (Sum), Maximum, Minimum <none> PT1M Yes
Saturation InnoDB Buffer Pool Read Requests

The number of logical read requests.
Innodb_buffer_pool_read_requests Count Total (Sum), Maximum, Minimum <none> PT1M Yes
Saturation InnoDB Buffer Pool Reads

The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk.
Innodb_buffer_pool_reads Count Total (Sum), Maximum, Minimum <none> PT1M Yes
Traffic Innodb Data Writes

The total number of data writes.
Innodb_data_writes Count Total (Sum), Maximum, Minimum <none> PT1M Yes
Latency Innodb Row Lock Time

The total time spent in acquiring row locks for InnoDB tables, in milliseconds.
Innodb_row_lock_time Milliseconds Average, Maximum, Minimum <none> PT1M Yes
Latency Innodb Row Lock Waits

The number of times operations on InnoDB tables had to wait for a row lock.
Innodb_row_lock_waits Count Total (Sum), Maximum, Minimum <none> PT1M Yes
Saturation Storage IO Percent

Storage I/O consumption percent
io_consumption_percent Percent Average, Maximum, Minimum <none> PT1M Yes
Traffic MySQL Lock Deadlocks

Number of deadlocks.
lock_deadlocks Count Total (Sum), Average, Maximum, Minimum <none> PT1M Yes
Traffic MySQL Lock Timeouts

Number of lock timeouts.
lock_timeouts Count Total (Sum), Average, Maximum, Minimum <none> PT1M Yes
Saturation Memory Percent

Memory Percent
memory_percent Percent Average, Maximum, Minimum <none> PT1M Yes
Traffic Host Network Out

Host Network egress in bytes
network_bytes_egress Bytes Total (Sum) <none> PT1M Yes
Traffic Host Network In

Host Network ingress in bytes
network_bytes_ingress Bytes Total (Sum) <none> PT1M Yes
Saturation Others Storage Used

Storage used by other files.
others_storage_used Bytes Average, Maximum, Minimum <none> PT1M Yes
Traffic Queries

Queries
Queries Count Total (Sum) <none> PT1M Yes
Availability Replica IO Status

Status for replication IO thread running
Replica_IO_Running Count Maximum <none> PT1M No
Availability Replica SQL Status

Status for replication SQL thread running
Replica_SQL_Running Count Maximum <none> PT1M No
Latency Replication Lag In Seconds

Replication lag in seconds
replication_lag Seconds Average, Maximum, Minimum <none> PT1M Yes
Saturation Serverlog Storage Limit

Serverlog Storage Limit
serverlog_storage_limit Bytes Maximum <none> PT1M Yes
Saturation Serverlog Storage Percent

Serverlog Storage Percent
serverlog_storage_percent Percent Average, Maximum, Minimum <none> PT1M Yes
Saturation Serverlog Storage Used

Serverlog Storage Used
serverlog_storage_usage Bytes Average, Maximum, Minimum <none> PT1M Yes
Traffic Slow Queries

The number of queries that have taken more than long_query_time seconds.
Slow_queries Count Total (Sum) <none> PT1M Yes
Traffic Storage IO Count

The number of storage I/O consumed.
storage_io_count Count Total (Sum) <none> PT1M No
Saturation Storage Limit

Storage Limit
storage_limit Bytes Maximum <none> PT1M Yes
Saturation Storage Percent

Storage Percent
storage_percent Percent Average, Maximum, Minimum <none> PT1M Yes
Saturation Storage Used

Storage Used
storage_used Bytes Average, Maximum, Minimum <none> PT1M Yes
Saturation Threads Running

The number of threads that are not sleeping.
Threads_running Count Total (Sum), Maximum, Minimum <none> PT1M Yes
Traffic Total Connections

Total Connections
total_connections Count Total (Sum) <none> PT1M Yes
Traffic MySQL History List Length

Length of the TRX_RSEG_HISTORY list.
trx_rseg_history_len Count Total (Sum), Average, Maximum, Minimum <none> PT1M Yes
Latency MySQL Uptime

The number of seconds that the server has been up.
Uptime Seconds Total (Sum), Maximum <none> PT1M Yes