Azure Database for MySQL Flexible Servers monitoring
- How-to guide
- 3-min read
- Published Aug 27, 2024
From 16 September 2024, Azure Database for MySQL Flexible Servers replaces Azure Database for MySQL Single Server.
The Azure Database for MySQL Flexible Servers overview page serves as a comprehensive overview of your MySQL servers and database instances. From here you can gain full visibility and check if your database is healthy, under-performing, or if there are any failed connections.
Prerequisites
- Dynatrace version 1.298+
- Environment ActiveGate version 1.195+
Enable monitoring
To learn how to enable service monitoring, see Enable service monitoring.
Optionally, for OneAgent integration, see how database activity is monitored.
View service metrics
You can view the service metrics in your Dynatrace environment either on the custom device overview page or on your Dashboards page.
View metrics on the custom device overview page
To access the custom device overview page
- Go to Technologies & Processes Classic.
- Filter by service name and select the relevant custom device group.
- Once you select the custom device group, you're on the custom device group overview page.
- The custom device group overview page lists all instances (custom devices) belonging to the group. Select an instance to view the custom device overview page.
View metrics on your dashboard
Once you add a service to monitoring, a preset dashboard for the respective service containing all recommended metrics is automatically created on your Dashboards page. You can look for specific dashboards by filtering by Preset and then by Name.
For existing monitored services, you might need to resave your credentials for the preset dashboard to appear on the Dashboards page. To resave your credentials, go to Settings > Cloud and virtualization > Azure, select the desired Azure instance, then select Save.
You can't make changes on a preset dashboard directly, but you can clone and edit it. To clone a dashboard, open the browse menu (…) and select Clone.
To remove a dashboard from the dashboards list, you can hide it. To hide a dashboard, open the browse menu (…) and select Hide.
Hiding a dashboard doesn't affect other users.
Available metrics
| Name | Description | Unit | Recommended |
|---|---|---|---|
| aborted_connections | Aborted connections | Count |  |
| active_connections | Active connections | Count | |
| active_transactions | Active transactions | Count | |
| backup_storage_used | Backup storage used | Byte | |
| binlog_storage_used | Binlog storage used | Byte | |
| cpu_credits_consumed | CPU credits consumed | Count | |
| cpu_credits_remaining | CPU credits remaining | Count | |
| Com_alter_table | Com alter table | Count | |
| Com_create_db | Com create DB | Count | |
| Com_create_table | Com create table | Count | |
| Com_delete | Com delete | Count | |
| Com_drop_db | Com drop DB | Count | |
| Com_drop_table | Com drop table | Count | |
| Com_insert | Com insert | Count | |
| Com_select | Com select | Count | |
| Com_update | Com update | Count | |
| data_storage_used | Data storage used | Byte | |
| HA_IO_status | Ha IO status | Count | |
| HA_SQL_status | Ha SQL status | Count | |
| HA_replication_lag | Ha replication lag | Second | |
| cpu_percent | Host CPU percent | Percent | |
| network_bytes_ingress | Host network in | Byte | |
| network_bytes_egress | Host network out | Byte | |
| ibdata1_storage_used | Ibdata1 storage used | Byte | |
| Innodb_buffer_pool_pages_data | Innodb buffer pool pages data | Count | |
| Innodb_buffer_pool_pages_dirty | Innodb buffer pool pages dirty | Count | |
| Innodb_buffer_pool_pages_flushed | Innodb buffer pool pages flushed | Count | |
| Innodb_buffer_pool_pages_free | Innodb buffer pool pages free | Count | |
| Innodb_buffer_pool_reads | Innodb buffer pool reads | Count | |
| Innodb_data_writes | Innodb data writes | Count | |
| Innodb_row_lock_time | Innodb row lock time | MilliSecond | |
| Innodb_row_lock_waits | Innodb row lock waits | Count | |
| memory_percent | Memory percent | Percent | |
| trx_rseg_history_len | Mysql history list length | Count | |
| lock_deadlocks | Mysql lock deadlocks | Count | |
| lock_timeouts | Mysql lock timeouts | Count | |
| Uptime | Mysql uptime | Second | |
| others_storage_used | Others storage used | Byte | |
| Queries | Queries | Count | |
| Replica_IO_Running | Replica IO status | Count | |
| Replica_SQL_Running | Replica SQL status | Count | |
| replication_lag | Replication lag in seconds | Second | |
| serverlog_storage_limit | Serverlog storage limit | Byte | |
| serverlog_storage_percent | Serverlog storage percent | Percent | |
| serverlog_storage_usage | Serverlog storage used | Byte | |
| Slow_queries | Slow queries | Count | |
| storage_io_count | Storage IO count | Count | |
| io_consumption_percent | Storage IO percent | Percent | |
| storage_limit | Storage limit | Byte | |
| storage_percent | Storage percent | Percent | |
| storage_used | Storage used | Byte | |
| Threads_running | Threads running | Count | |
| total_connections | Total connections | Count |