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	<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, Average, Maximum, Minimum	<none>	PT1M	Yes
Saturation	Available Memory Bytes (deprecated) Amount of physical memory, in bytes. Deprecated, Please check memory_percent for the memory usage.	available_memory_bytes	Bytes	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	<none>	PT1M	Yes
Traffic	Com Create DB The number of times CREATE DB statement has been executed.	Com_create_db	Count	Total	<none>	PT1M	Yes
Traffic	Com Create Table The number of times CREATE TABLE statement has been executed.	Com_create_table	Count	Total	<none>	PT1M	Yes
Traffic	Com Delete The number of times DELETE statement has been executed.	Com_delete	Count	Total	<none>	PT1M	Yes
Traffic	Com Drop DB The number of times DROP DB statement has been executed.	Com_drop_db	Count	Total	<none>	PT1M	Yes
Traffic	Com Drop Table The number of times DROP TABLE statement has been executed.	Com_drop_table	Count	Total	<none>	PT1M	Yes
Traffic	Com Insert The number of times INSERT statement has been executed.	Com_insert	Count	Total	<none>	PT1M	Yes
Traffic	Com Select The number of times SELECT statement has been executed.	Com_select	Count	Total	<none>	PT1M	Yes
Traffic	Com Update The number of times UPDATE statement has been executed.	Com_update	Count	Total	<none>	PT1M	Yes
Saturation	CPU Credits Consumed CPU Credits Consumed	cpu_credits_consumed	Count	Average, Maximum, Minimum	<none>	PT1M	Yes
Saturation	CPU Credits Remaining CPU Credits Remaining	cpu_credits_remaining	Count	Average, Maximum, Minimum	<none>	PT1M	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, 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, 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, Maximum, Minimum	<none>	PT1M	Yes
Saturation	InnoDB Buffer Pool Read Requests The number of logical read requests.	Innodb_buffer_pool_read_requests	Count	Total, 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, Maximum, Minimum	<none>	PT1M	Yes
Traffic	Innodb Data Writes The total number of data writes.	Innodb_data_writes	Count	Total, 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, 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, Average, Maximum, Minimum	<none>	PT1M	Yes
Traffic	MySQL Lock Row Lock Waits Number of times a row lock had to be waited for (innodb_row_lock_waits).	lock_row_lock_waits	Count	Total, Average, Maximum, Minimum	<none>	PT1M	Yes
Traffic	MySQL Lock Timeouts Number of lock timeouts.	lock_timeouts	Count	Total, 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	<none>	PT1M	Yes
Traffic	Host Network In Host Network ingress in bytes	network_bytes_ingress	Bytes	Total	<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	<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	<none>	PT1M	Yes
Traffic	Storage IO Count The number of storage I/O consumed.	storage_io_count	Count	Total	<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 Throttle Count (deprecated) Storage IO requests throttled in the selected time range. Deprecated, please check Storage IO Percent for throttling.	storage_throttle_count	Count	Maximum	<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, Maximum, Minimum	<none>	PT1M	Yes
Traffic	Total Connections Total Connections	total_connections	Count	Total	<none>	PT1M	Yes
Traffic	MySQL History List Length Length of the TRX_RSEG_HISTORY list.	trx_rseg_history_len	Count	Total, Average, Maximum, Minimum	<none>	PT1M	Yes
Latency	MySQL Uptime The number of seconds that the server has been up.	Uptime	Seconds	Total, Maximum	<none>	PT1M	Yes