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 - Metrics export using data collection rules and 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

Next steps