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: Availability
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| HA IO Status Status for replication IO thread running |
HA_IO_status |
Count | Maximum | <none> | PT1M | Yes |
| HA SQL Status Status for replication SQL thread running |
HA_SQL_status |
Count | Maximum | <none> | PT1M | Yes |
| Replica IO Status Status for replication IO thread running |
Replica_IO_Running |
Count | Maximum | <none> | PT1M | No |
| Replica SQL Status Status for replication SQL thread running |
Replica_SQL_Running |
Count | Maximum | <none> | PT1M | No |
Category: Errors
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Aborted Connections Aborted Connections |
aborted_connections |
Count | Total (Sum) | <none> | PT1M | Yes |
Category: Latency
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| HA Replication Lag HA Replication lag in seconds |
HA_replication_lag |
Seconds | Average, Maximum, Minimum | <none> | PT1M | Yes |
| 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 |
| 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 |
| Replication Lag In Seconds Replication lag in seconds |
replication_lag |
Seconds | Average, Maximum, Minimum | <none> | PT1M | Yes |
| MySQL Uptime The number of seconds that the server has been up. |
Uptime |
Seconds | Total (Sum), Maximum | <none> | PT1M | Yes |
Category: Saturation
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Backup Storage Used Backup Storage Used |
backup_storage_used |
Bytes | Average, Maximum, Minimum | <none> | PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Binlog Storage Used Storage used by Binlog files. |
binlog_storage_used |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| CPU Credits Consumed CPU Credits Consumed |
cpu_credits_consumed |
Count | Average, Maximum, Minimum | <none> | PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| CPU Credits Remaining CPU Credits Remaining |
cpu_credits_remaining |
Count | Average, Maximum, Minimum | <none> | PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Host CPU Percent Host CPU Percent |
cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Data Storage Used Storage used by data files. |
data_storage_used |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Ibdata1 Storage Used Storage used by ibdata1 files. |
ibdata1_storage_used |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| 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 |
| 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 |
| 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 |
| InnoDB Buffer Pool Read Requests The number of logical read requests. |
Innodb_buffer_pool_read_requests |
Count | Total (Sum), Maximum, Minimum | <none> | PT1M | Yes |
| 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 |
| Storage IO Percent Storage I/O consumption percent |
io_consumption_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Memory Percent Memory Percent |
memory_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Others Storage Used Storage used by other files. |
others_storage_used |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Serverlog Storage Limit Serverlog Storage Limit |
serverlog_storage_limit |
Bytes | Maximum | <none> | PT1M | Yes |
| Serverlog Storage Percent Serverlog Storage Percent |
serverlog_storage_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Serverlog Storage Used Serverlog Storage Used |
serverlog_storage_usage |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Storage Limit Storage Limit |
storage_limit |
Bytes | Maximum | <none> | PT1M | Yes |
| Storage Percent Storage Percent |
storage_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Storage Used Storage Used |
storage_used |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Threads Running The number of threads that are not sleeping. |
Threads_running |
Count | Total (Sum), Maximum, Minimum | <none> | PT1M | Yes |
Category: Traffic
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Active Connections Active Connections |
active_connections |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Active Transactions Number of active transactions. |
active_transactions |
Count | Total (Sum), Average, Maximum, Minimum | <none> | PT1M | Yes |
| Com Alter Table The number of times ALTER TABLE statement has been executed. |
Com_alter_table |
Count | Total (Sum) | <none> | PT1M | Yes |
| Com Create DB The number of times CREATE DB statement has been executed. |
Com_create_db |
Count | Total (Sum) | <none> | PT1M | Yes |
| Com Create Table The number of times CREATE TABLE statement has been executed. |
Com_create_table |
Count | Total (Sum) | <none> | PT1M | Yes |
| Com Delete The number of times DELETE statement has been executed. |
Com_delete |
Count | Total (Sum) | <none> | PT1M | Yes |
| Com Drop DB The number of times DROP DB statement has been executed. |
Com_drop_db |
Count | Total (Sum) | <none> | PT1M | Yes |
| Com Drop Table The number of times DROP TABLE statement has been executed. |
Com_drop_table |
Count | Total (Sum) | <none> | PT1M | Yes |
| Com Insert The number of times INSERT statement has been executed. |
Com_insert |
Count | Total (Sum) | <none> | PT1M | Yes |
| Com Select The number of times SELECT statement has been executed. |
Com_select |
Count | Total (Sum) | <none> | PT1M | Yes |
| Com Update The number of times UPDATE statement has been executed. |
Com_update |
Count | Total (Sum) | <none> | PT1M | Yes |
| 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 |
| Innodb Data Writes The total number of data writes. |
Innodb_data_writes |
Count | Total (Sum), Maximum, Minimum | <none> | PT1M | Yes |
| MySQL Lock Deadlocks Number of deadlocks. |
lock_deadlocks |
Count | Total (Sum), Average, Maximum, Minimum | <none> | PT1M | Yes |
| MySQL Lock Timeouts Number of lock timeouts. |
lock_timeouts |
Count | Total (Sum), Average, Maximum, Minimum | <none> | PT1M | Yes |
| Host Network Out Host Network egress in bytes |
network_bytes_egress |
Bytes | Total (Sum) | <none> | PT1M | Yes |
| Host Network In Host Network ingress in bytes |
network_bytes_ingress |
Bytes | Total (Sum) | <none> | PT1M | Yes |
| Queries Queries |
Queries |
Count | Total (Sum) | <none> | PT1M | Yes |
| Slow Queries The number of queries that have taken more than long_query_time seconds. |
Slow_queries |
Count | Total (Sum) | <none> | PT1M | Yes |
| Storage IO Count The number of storage I/O consumed. |
storage_io_count |
Count | Total (Sum) | <none> | PT1M | No |
| Total Connections Total Connections |
total_connections |
Count | Total (Sum) | <none> | PT1M | Yes |
| MySQL History List Length Length of the TRX_RSEG_HISTORY list. |
trx_rseg_history_len |
Count | Total (Sum), Average, Maximum, Minimum | <none> | PT1M | Yes |