Azure Integration - Database for MySQL
Mackerel supports obtaining and monitoring Database for MySQL metrics in Azure Integration. Billable targets are determined using the conversion 1 resource = 1 Micro Host.
Please refer to the following page for Azure Integration configuration methods and a list of supported Azure services.
Azure Integration
Obtaining metrics
The following metrics can be retrieved for Database for MySQL. A maximum of 36 metrics will be retrieved. The actual metrics obtained may be reduced depending on the server SKU and role. For Metric explanations, please refer to the Azure documentation.
| Graph names | Metric | Metric name in Mackerel | Unit | Aggregation Type |
|---|---|---|---|---|
| Backup Storage used | backup_storage_used | azure.db_for_mysql.backup_storage_used.bytes | bytes | Average |
| Connections | active_connections aborted_connections total_connections | azure.db_for_mysql.connections.active azure.db_for_mysql.connections.aborted azure.db_for_mysql.connections.total | float | Average Total Total |
| CPU credits Remaining/Consumed | cpu_credits_remaining cpu_credits_consumed | azure.db_for_mysql.cpu_credits.remaining azure.db_for_mysql.cpu_credits.consumed | float | Average |
| CPU percent | cpu_percent | azure.db_for_mysql.cpu.percent | percentage | Average |
| HA IO/SQL Status | HA_IO_status HA_SQL_status | azure.db_for_mysql.ha_status.io azure.db_for_mysql.ha_status.sql | float | Average |
| InnoDB Buffer Pool Reads/Requests Count | Innodb_buffer_pool_reads Innodb_buffer_pool_read_requests | azure.db_for_mysql.innodb_buffer_pool_read.reads azure.db_for_mysql.innodb_buffer_pool_read.requests | float | Total |
| IO percent | io_consumption_percent | azure.db_for_mysql.io.percent | percentage | Average |
| Memory percent | memory_percent | azure.db_for_mysql.memory.percent | percentage | Average |
| MySQL DDL Command | Com_create_db Com_drop_db Com_create_table Com_drop_table Com_alter_table | azure.db_for_mysql.cmd_ddl.Com_create_db azure.db_for_mysql.cmd_ddl.Com_drop_db azure.db_for_mysql.cmd_ddl.Com_create_table azure.db_for_mysql.cmd_ddl.Com_drop_table azure.db_for_mysql.cmd_ddl.Com_alter_table | float | Total |
| MySQL DML Command | Com_select Com_update Com_insert Com_delete | azure.db_for_mysql.cmd_dml.Com_select azure.db_for_mysql.cmd_dml.Com_update azure.db_for_mysql.cmd_dml.Com_insert azure.db_for_mysql.cmd_dml.Com_delete | float | Total |
| Network In/Out | network_bytes_egress network_bytes_ingress | azure.db_for_mysql.network.out azure.db_for_mysql.network.in | bytes | Total |
| Total/Slow Queries | Queries Slow_queries | azure.db_for_mysql.queries.total azure.db_for_mysql.queries.slow | float | Total |
| Replica IO/SQL Running | Replica_IO_Running Replica_SQL_Running | db_for_mysql.replica_running.io db_for_mysql.replica_running.sql | float | Average |
| Replication lag in seconds | replication_lag | db_for_mysql.replication_lag | seconds | Maximum |
| Server Log storage limit/used | serverlog_storage_limit serverlog_storage_usage | azure.db_for_mysql.server_log_storage_limit_used.limit azure.db_for_mysql.server_log_storage_limit_used.used | bytes | Maximum Average |
| Server Log storage percent | serverlog_storage_percent | azure.db_for_mysql.server_log_storage.percent | percentage | Average |
| Storage IO count | storage_io_count | azure.db_for_mysql.storage_io_count | float | Total |
| Storage limit/used | storage_limit storage_used | azure.db_for_mysql.storage_limit_used.limit azure.db_for_mysql.storage_limit_used.used | bytes | Maximum Average |
| Storage percent | storage_percent | azure.db_for_mysql.storage.percent | percentage | Average |
Notes
- Of the graphs / metrics that can be obtained with Azure integration listed above, Backup Storage used is normally obtained with a 15-minute interval granularity according to the specifications of the Azure Monitor API used by Azure integration. Also, updates can have a latency of up to 30 minutes.