Azure Database for MySQL Flexible Servers monitoring

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

  1. Go to Technologies & Processes or Technologies & Processes Classic (latest Dynatrace).
  2. Filter by service name and select the relevant custom device group.
  3. Once you select the custom device group, you're on the custom device group overview page.
  4. 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.

Clone hide azure

Available metrics

Name
Description
Unit
Recommended
aborted_connections
Aborted connections
Count
Applicable
active_connections
Active connections
Count
Applicable
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
Applicable
network_bytes_ingress
Host network in
Byte
Applicable
network_bytes_egress
Host network out
Byte
Applicable
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
Applicable
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
Applicable
serverlog_storage_limit
Serverlog storage limit
Byte
serverlog_storage_percent
Serverlog storage percent
Percent
Applicable
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
Applicable
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