MySQL Flexible Server metrics

Azure MySQL Flexible Server is a fully managed, production-ready relational database service in the Microsoft Cloud. Use the Azure Resource Manager to gather metrics for this resource, then ensure your cloud platform is configured in SolarWinds Observability SaaS to collect this resource type's data. See Add an Azure cloud account.

Depending on the subscription pricing tier of your Azure account or its resources, additional metrics may be available for this entity. To collect additional Azure metrics, select the premium pricing tier when configuring your Azure namespaces.

Many of the collected metrics from MySQL Flexible Server entities are displayed as widgets in SolarWinds Observability explorers; additional metrics may be collected and available in the Metrics Explorer. You can also create an alert for when an entity's metric value moves out of a specific range. See Entities in SolarWinds Observability SaaS for information about entity types in SolarWinds Observability SaaS.

The following table lists some of the metrics collected for these entities. To see the MySQL Flexible Server metrics in the Metrics Explorer, type azure.mysql.flexible in the search box.

Metric	Units	Description
sw.metrics.healthscore	Percent (%)	Health score. A health score provides real-time insight into the overall health and performance of your monitored entities. The health score is calculated based on anomalies detected for the entity, alerts triggered for the entity's metrics, and the status of the entity. The health score is displayed as a single numerical value that ranges from a Good (70-100) to Moderate (40-69) to Bad (0-39) distinction. To view the health score for MySQL Flexible Server entities in the Metrics Explorer, filter the sw.metrics.healthscore metric by entity_types and select azuremysqlflexible.
azure.mysql.flexible.aborted_connections	Count	Aborted Connections.
azure.mysql.flexible.active_connections	Count	Active Connections.
azure.mysql.flexible.available_memory_bytes	bytes	Amount of physical memory, in bytes.
azure.mysql.flexible.cpu_percent	Percent (%)	Host CPU Percent.
azure.mysql.flexible.backup_storage_used	bytes	Backup Storage Used.
azure.mysql.flexible.binlog_storage_used	bytes	Storage used by Binlog files.
azure.mysql.flexible.memory_percent	Percent (%)	Host Memory Percent.
azure.mysql.flexible.network_bytes_egress	bytes	Host Network egress in bytes.
azure.mysql.flexible.network_bytes_ingress	bytes	Host Network ingress in bytes.
azure.mysql.flexible.Queries	Count	Number of queries.
azure.mysql.flexible.Slow_queries	Count	The number of queries that have taken more than long_query_time seconds.
azure.mysql.flexible.replication_lag	seconds (s)	Replication lag in seconds.
azure.mysql.flexible.storage_io_count	Count	The number of storage I/O consumed.
azure.mysql.flexible.storage_limit	bytes	Storage Limit.
azure.mysql.flexible.storage_used	bytes	Storage Used.
azure.mysql.flexible.total_connections	Count	Total Connections.
azure.mysql.flexible.storage_percent	Percent (%)	Percentage of storage.
azure.mysql.flexible.Threads_running	Count	The number of threads that are not sleeping.
azure.mysql.flexible.Com_alter_table	Count	The number of times ALTER TABLE statement has been executed.
azure.mysql.flexible.Com_create_db	Count	The number of times CREATE DB statement has been executed.
azure.mysql.flexible.Com_create_table	Count	The number of times CREATE TABLE statement has been executed.
azure.mysql.flexible.Com_delete	Count	The number of times DELETE statement has been executed.
azure.mysql.flexible.Com_drop_db	Count	The number of times DROP DB statement has been executed.
azure.mysql.flexible.Com_drop_table	Count	The number of times DROP TABLE statement has been executed.
azure.mysql.flexible.Com_insert	Count	The number of times INSERT statement has been executed.
azure.mysql.flexible.Com_select	Count	The number of times SELECT statement has been executed.
azure.mysql.flexible.Com_update	Count	The number of times UPDATE statement has been executed.
azure.mysql.flexible.cpu_credits_consumed	Count	CPU Credits Consumed.
azure.mysql.flexible.cpu_credits_remaining	Count	CPU Credits Remaining.
azure.mysql.flexible.data_storage_used	bytes	Storage used by data files.
azure.mysql.flexible.HA_IO_status	Count	Status for replication IO thread running.
azure.mysql.flexible.HA_replication_lag	seconds (s)	HA Replication lag in seconds.
azure.mysql.flexible.HA_SQL_status	Count	Status for replication SQL thread running.
azure.mysql.flexible.ibdata1_storage_used	bytes	Storage used by ibdata1 files.
azure.mysql.flexible.Innodb_buffer_pool_pages_data	Count	The number of pages in the InnoDB buffer pool containing data.
azure.mysql.flexible.Innodb_buffer_pool_pages_dirty	Count	The current number of dirty pages in the InnoDB buffer pool.
azure.mysql.flexible.Innodb_buffer_pool_pages_flushed	Count	The number of requests to flush pages from the InnoDB buffer pool.
azure.mysql.flexible.Innodb_buffer_pool_pages_free	Count	The number of free pages in the InnoDB buffer pool.
azure.mysql.flexible.Innodb_buffer_pool_read_requests	Count	The number of logical read requests.
azure.mysql.flexible.Innodb_buffer_pool_reads	Count	The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk.
azure.mysql.flexible.Innodb_data_writes	Count	The total number of data writes.
azure.mysql.flexible.Innodb_row_lock_time	milliseconds (ms)	The total time spent in acquiring row locks for InnoDB tables, in milliseconds.
azure.mysql.flexible.Innodb_row_lock_waits	Count	The number of times operations on InnoDB tables had to wait for a row lock.
azure.mysql.flexible.io_consumption_percent	Percent (%)	Storage I/O consumption percent.
azure.mysql.flexible.others_storage_used	bytes	Storage used by other files.
azure.mysql.flexible.Replica_IO_Running	Count	Status for replication IO thread running.
azure.mysql.flexible.Replica_SQL_Running	Count	Status for replication SQL thread running.
azure.mysql.flexible.serverlog_storage_limit	bytes	Serverlog Storage Limit.
azure.mysql.flexible.serverlog_storage_percent	Percent (%)	Serverlog Storage Percent.
azure.mysql.flexible.serverlog_storage_usage	bytes	Serverlog Storage Used.
azure.mysql.flexible.storage_throttle_count	Count	Storage IO requests throttled in the selected time range. Deprecated, please check Storage IO Percent for throttling.