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 |