Microsoft Azure DB for MySQL

Overview

Azure Database for MySQL provides fully managed, enterprise-ready community MySQL database as a service.

Get metrics from Azure Database for MySQL to:

  • Visualize the performance of your MySQL databases.
  • Correlate the performance of your MySQL databases with your applications.

Setup

Installation

If you haven’t already, set up the Microsoft Azure integration first. There are no other installation steps that need to be performed.

Data Collected

Metrics

azure.dbformysql_flexibleservers.aborted_connections
(count)
Aborted Connections
Shown as connection
azure.dbformysql_flexibleservers.active_connections
(gauge)
Active Connections
Shown as connection
azure.dbformysql_flexibleservers.active_transactions
(gauge)
Number of active transactions
Shown as transaction
azure.dbformysql_flexibleservers.backup_storage_used
(gauge)
Backup Storage used
Shown as byte
azure.dbformysql_flexibleservers.binlog_storage_used
(gauge)
Storage used by Binlog files
Shown as byte
azure.dbformysql_flexibleservers.com_alter_table
(count)
The total number of times ALTER TABLE statement has been executed
azure.dbformysql_flexibleservers.com_create_db
(count)
The total number of times CREATE DB statement has been executed
azure.dbformysql_flexibleservers.com_create_table
(count)
The total number of times CREATE TABLE statement has been executed
azure.dbformysql_flexibleservers.com_drop_db
(count)
The total number of times DROP DB statement has been executed
azure.dbformysql_flexibleservers.com_drop_table
(count)
The total number of times DROP TABLE statement has been executed
azure.dbformysql_flexibleservers.com_insert
(count)
The total number of times INSERT statement has been executed
azure.dbformysql_flexibleservers.com_select
(count)
The total number of times SELECT statement has been executed
azure.dbformysql_flexibleservers.com_update
(count)
The total number of times UPDATE statement has been executed
azure.dbformysql_flexibleservers.core_count
(gauge)
Core count
azure.dbformysql_flexibleservers.count
(gauge)
The count of Azure MySQL server integration
azure.dbformysql_flexibleservers.cpu_credits_consumed
(gauge)
CPU Credits Consumed
Shown as byte
azure.dbformysql_flexibleservers.cpu_credits_remaining
(gauge)
CPU Credits Remaining
Shown as byte
azure.dbformysql_flexibleservers.cpu_percent
(gauge)
Host CPU Percent
Shown as percent
azure.dbformysql_flexibleservers.data_storage_used
(gauge)
Storage used by data files
Shown as byte
azure.dbformysql_flexibleservers.ha_io_status
(gauge)
Status for replication IO thread running
azure.dbformysql_flexibleservers.ha_replication_lag
(gauge)
HA Replication lag in seconds
Shown as second
azure.dbformysql_flexibleservers.ha_sql_status
(gauge)
Status for replication SQL thread running
azure.dbformysql_flexibleservers.ibdata1_storage_used
(gauge)
Storage used by ibdata1 files
Shown as byte
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_data
(count)
The number of pages in the InnoDB buffer pool containing data
Shown as page
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_data_dirty
(count)
The current number of dirty pages in the InnoDB buffer pool
Shown as page
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_data_flushed
(gauge)
The number of requests to flush pages from the InnoDB buffer pool
Shown as request
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_free
(count)
The total number of free pages in the InnoDB buffer pool
Shown as page
azure.dbformysql_flexibleservers.innodb_buffer_pool_read_requests
(count)
The total number of logical read requests
Shown as request
azure.dbformysql_flexibleservers.innodb_buffer_pool_reads
(count)
The total number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk
Shown as read
azure.dbformysql_flexibleservers.innodb_data_writes
(count)
The total number of data writes
Shown as write
azure.dbformysql_flexibleservers.innodb_row_lock_time
(gauge)
The total time spent in acquiring row locks for InnoDB tables, in milliseconds
Shown as millisecond
azure.dbformysql_flexibleservers.innodb_row_lock_waits
(gauge)
The number of times operations on InnoDB tables had to wait for a row lock
azure.dbformysql_flexibleservers.io_consumption_percent
(gauge)
IO percent
Shown as percent
azure.dbformysql_flexibleservers.lock_deadlocks
(gauge)
Number of deadlocks
Shown as deadlock
azure.dbformysql_flexibleservers.lock_timeouts
(gauge)
Number of lock timeouts
azure.dbformysql_flexibleservers.memory_percent
(gauge)
Memory percent
Shown as percent
azure.dbformysql_flexibleservers.network_bytes_egress
(count)
Network Out across active connections
Shown as byte
azure.dbformysql_flexibleservers.network_bytes_ingress
(count)
Network In across active connections
Shown as byte
azure.dbformysql_flexibleservers.others_storage_used
(gauge)
Storage used by other files
Shown as byte
azure.dbformysql_flexibleservers.queries
(count)
The number of queries
Shown as query
azure.dbformysql_flexibleservers.replica_io_running
(gauge)
Status for replication IO thread running
azure.dbformysql_flexibleservers.replica_sql_running
(gauge)
Status for replication SQL thread running
azure.dbformysql_flexibleservers.replication_lag
(gauge)
Replication lag in seconds
Shown as second
azure.dbformysql_flexibleservers.serverlog_storage_limit
(gauge)
Serverlog Storage Limit
Shown as byte
azure.dbformysql_flexibleservers.serverlog_storage_percent
(gauge)
Serverlog Storage Percent
Shown as percent
azure.dbformysql_flexibleservers.serverlog_storage_usage
(gauge)
Serverlog Storage Usage
Shown as byte
azure.dbformysql_flexibleservers.slow_queries
(count)
The total number of queries that have taken more than longquerytime seconds
Shown as query
azure.dbformysql_flexibleservers.storage_io_count
(count)
The number of storage I/O consumed
azure.dbformysql_flexibleservers.status
(gauge)
Status of Azure DB for MySQL integration (deprecated)
azure.dbformysql_flexibleservers.storage_limit
(gauge)
Storage limit
Shown as byte
azure.dbformysql_flexibleservers.storage_percent
(gauge)
DB storage in percent
Shown as percent
azure.dbformysql_flexibleservers.storage_used
(gauge)
DB storage used in bytes
Shown as byte
azure.dbformysql_flexibleservers.threads_running
(count)
The total number of threads that are not sleeping
Shown as thread
azure.dbformysql_flexibleservers.total_connections
(count)
Total Connections
Shown as connection
azure.dbformysql_flexibleservers.threads_running
(count)
The total number of threads that are not sleeping
Shown as thread
azure.dbformysql_flexibleservers.trx_rseg_history_len
(gauge)
Length of the TRXRSEGHISTORY list
azure.dbformysql_flexibleservers.uptime
(gauge)
The number of seconds that the server has been up
Shown as second
azure.dbformysql_servers.active_connections
(gauge)
Active Connections
Shown as connection
azure.dbformysql_servers.backup_storage_used
(gauge)
Backup Storage used
Shown as byte
azure.dbformysql_servers.connections_failed
(count)
Failed Connections
Shown as connection
azure.dbformysql_servers.core_count
(gauge)
Core count
azure.dbformysql_servers.count
(gauge)
The count of Azure MySQL server integration
azure.dbformysql_servers.cpu_percent
(gauge)
CPU percent
Shown as percent
azure.dbformysql_servers.io_consumption_percent
(gauge)
IO percent
Shown as percent
azure.dbformysql_servers.memory_percent
(gauge)
Memory percent
Shown as percent
azure.dbformysql_servers.network_bytes_egress
(count)
Network Out across active connections
Shown as byte
azure.dbformysql_servers.network_bytes_ingress
(count)
Network In across active connections
Shown as byte
azure.dbformysql_servers.seconds_behind_master
(gauge)
Replication lag in seconds
Shown as second
azure.dbformysql_servers.serverlog_storage_limit
(gauge)
Server Log storage limit
Shown as byte
azure.dbformysql_servers.serverlog_storage_percent
(gauge)
Server Log storage percent
Shown as percent
azure.dbformysql_servers.serverlog_storage_usage
(gauge)
Server Log storage used
Shown as byte
azure.dbformysql_servers.status
(gauge)
Status of Azure DB for MySQL integration (deprecated)
azure.dbformysql_servers.storage_limit
(gauge)
Storage limit
Shown as byte
azure.dbformysql_servers.storage_percent
(gauge)
DB storage in percent
Shown as percent
azure.dbformysql_servers.storage_used
(gauge)
DB storage used in bytes
Shown as byte

Events

The Azure Database for MySQL integration does not include any events.

Service Checks

The Azure Database for MySQL integration does not include any service checks.

Troubleshooting

Need help? Contact Datadog support.