--- title: Azure DB for MySQL description: Track key Azure DB for MySQL metrics. breadcrumbs: Docs > Integrations > Azure DB for MySQL --- # Azure DB for MySQL ## Overview{% #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{% #setup %} ### Installation{% #installation %} If you haven't already, set up the [Microsoft Azure integration](https://docs.datadoghq.com/integrations/azure.md) first. There are no other installation steps that need to be performed. ## Data Collected{% #data-collected %} ### Metrics{% #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 | | **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 long_query_time seconds*Shown as query* | | **azure.dbformysql\_flexibleservers.storage\_io\_count**(count) | The number of storage I/O consumed | | **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 TRX_RSEG_HISTORY 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.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* | | **azure.dbformysql\_flexibleservers.innodb\_buffer\_pool\_pages\_dirty**(gauge) | Current number of dirty pages in the innodb buffer pool. | | **azure.dbformysql\_flexibleservers.sort\_merge\_passes**(gauge) | Number of merge passes that the sort algorithm has had to do. If this value is large, you should consider increasing the value of the sort_buffer_size system variable. | | **azure.dbformysql\_flexibleservers.com\_delete**(count) | Number of times DELETE statement has been executed. | | **azure.dbformysql\_flexibleservers.innodb\_buffer\_pool\_pages\_flushed**(gauge) | Number of requests to flush pages from the innodb buffer pool. | ### Events{% #events %} The Azure Database for MySQL integration does not include any events. ### Service Checks{% #service-checks %} The Azure Database for MySQL integration does not include any service checks. ## Troubleshooting{% #troubleshooting %} Need help? Contact [Datadog support](https://docs.datadoghq.com/help/).