Monitor Azure Database for MySQL - Flexible Server by using Azure Monitor workbooks

  • Article

APPLIES TO: Azure Database for MySQL - Flexible Server

Azure Database for MySQL flexible server is now integrated with Azure Monitor workbooks. With workbooks, you get a flexible canvas for analyzing data and creating rich visual reports within the Azure portal. Workbooks allow you to tap into multiple data sources across Azure and combine them into unified interactive experiences. Workbook templates serve as curated reports that are designed for flexible reuse by multiple users and teams.

When you open a template, you create a transient workbook that's populated with the contents of the template. With this integration, the server links to workbooks and a few sample templates, which can help you monitor the service at scale. You can edit these templates, customize them to your requirements, and pin them to the dashboard to create a focused and organized view of Azure resources.

In this article, you'll learn about the various workbook templates that are available for your flexible server.

Azure Database for MySQL flexible server has three available templates:

  • Overview: Displays an instance summary and top-level metrics to help you visualize and understand the resource utilization on your server. This template displays the following views:

    • Server Summary
    • Database Summary
    • Connection Metrics
    • Performance Metrics
    • Storage Metrics

  • Auditing: Displays a summary and details of the auditing events that are collected for the server. This template displays the following views:

    • Administrative Actions on the service
    • Audit Summary
    • Audit Connection Events Summary
    • Audit Connection Events
    • Table Access Summary
    • Errors Identified

  • Query Performance Insight: Displays a summary and details of query workload on the instance, long running query, slow query analysis, and connection metrics. This template displays the following views:

    • Query Load
    • Total Active Connections
    • Slow Query Trend (>10 seconds of query time)
    • Slow Query Details
    • List top 5 longest queries
    • Summarize slow queries by minimum, maximum, average, and standard deviation query time

You can also edit and customize these templates according to your requirements. For more information, see Azure Workbooks.

Access the workbook templates

To view the templates in the Azure portal, go to the Monitoring pane for Azure Database for MySQL flexible server, and then select Workbooks.

Screenshot showing the 'Overview', 'Auditing', and 'Query Performance Insight' templates on the Workbooks pane.

You can also display the list of templates by going to the Public Templates pane.

Diagram that shows the 'Overview', 'Auditing', and 'Query Performance Insight' templates on the 'Public Templates' pane.

Next steps