MySQL on Azure Flex metrics and alerts

This documentation contains a list of metrics and alerts that are available when monitoring MySQL on Azure Flex instances.

If you can't find a specific metric or alert you would like to use when monitoring your Azure Flex instances, send us feedback.

Azure Flex host metrics

To get access to machine metrics in Azure Flex you need to provide Redgate Monitor with your Azure API credentials. 

The following table summarizes the host metrics that Redgate Monitor can collect, for Azure Flex servers, only if Azure Enhanced Monitoring is enabled for your Azure Flex instances:

Machine: processor time

Machine: memory used

Network utilization

Metrics

The following lists the metrics Redgate Monitor collects and exposes on the Analysis page:

MySQL on Azure Flex metrics

Available at the instance level:

Connections / sec 

Buffer pool wait free events / sec 

Connection errors / sec 

Deadlocks / sec 

Threads connected 

Lock waiting time / sec 

Threads running 

Pending data reads 

Queries / sec 

Pending data writes 

Query errors / sec 

Pending fsyncs operations 

Bytes read / sec 

Full index scans / sec 

Bytes written / sec 

Full table scans rows read / sec 

Transactions begun / sec 

Full table scans / sec 

Transactions committed / sec

Index scan rows read / sec

Transactions rolled-back / sec 

Joins performing full table scan / sec 

Prepared statement execution ratio 

Joins performing a range check / sec 

Number of cached prepared statements 

Seeks / sec

Buffer pool cache hit ratio 

Queries waiting for a lock / sec

Buffer pool percentage free 

Sort operations / sec

Buffer pool percentage dirty 

 

Alerts

The following is a list of alerts available for MySQL on Azure Flex:

    • MySQL specific alerts
      • Database instance error log entry 
      • Instance unreachable 
      • Long-running query
      • Monitoring stopped (instance credentials)
      • Monitoring error (instance data collection)
    • Host alerts
      • Internal Redgate Monitor error (host)
      • Monitoring error (host data collection)
      • Monitoring stopped (host credentials)
      • Physical memory
      • Processor under-utilization
      • Processor utilization

Didn't find what you were looking for?