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 |