MySQL monitoring

Learn how to monitor your MySQL database using the MySQL ActiveGate extension. The extension supports MySQL versions 5.7 and 8, as well as the corresponding versions of MariaDB and Percona Server.

Get started

To get started, select the chat button in the upper-right corner of the Dynatrace menu bar to contact a Dynatrace ONE Product Specialist. Dynatrace ONE will make sure you have what you need to monitor MySQL databases.

Prerequisites

  • Environment ActiveGate with remote access to the MySQL database server
  • A MySQL database user

Extension installation

To install the MySQL database extension

  1. Get the extension ZIP install file from your Dynatrace ONE Product Specialist via live chat. Don't rename the file.

  2. Unzip the ZIP file to the plugin_deployment directory of your ActiveGate host.

  3. In Dynatrace, go to Settings > Monitoring > Monitored technologies.

  4. Select Add new technology monitoring and then Add ActiveGate extension.

  5. Select Upload extension and upload the ZIP file.

  6. After you upload the extension, go to Settings > Monitoring > Monitored technologies and switch to the Custom extensions tab.

  7. Find the extension and select it to open it for Endpoint configuration.

  8. Enter the endpoint information.

    Setting Details

    Endpoint name

    Enter a meaningful endpoint name.

    User

    The MySQL database user name.

    Password

    The MySQL database user password.

    Host Name

    The DNS or IP address that the database resides on.

    Port number

    The default port is 3306.

    Choose ActiveGate

    Type or select an ActiveGate.

Metrics

Available metrics are listed below.

Connections

  • Connections
  • Connection Errors

Throughput

  • Queries
  • Questions
  • Slow Queries
  • Slow Queries Rate

Threads

  • Connected
  • Created
  • Running

Commands

  • Delete
  • Delete-multi
  • Insert
  • Insert-select
  • Select
  • Replace-select
  • Update
  • Update-multi

InnoDB

  • InnoDB file I/O - reads
  • InnoDB file I/O - writes
  • InnoDB buffer pool size
  • InnoDB buffer pool pages - Total
  • InnoDB buffer pool pages - Dirty
  • InnoDB buffer pool pages - Free
  • InnoDB buffer pool pages - Data

Query Cache

  • Query Cache Hits
  • Query Cache - Not cached
  • Free memory
  • Queries in cache

Tables

  • Table locks - Waited
  • Table locks - Immediate
  • Created temporary tables - Disk Tables
  • Created temporary tables - Tables