MySQL monitoring

Deprecation notice

This extension documentation is now deprecated and will no longer be updated. We recommend using the new MySQL extension for improved functionality and support.

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.

Prerequisites

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

This extension uses the "show global status" and "show global variables" commands. The commands don't require any specific privileges, only the ability to connect to the server.

Extension installation

To install the MySQL database extension

  1. In Dynatrace Hub, select MySQL (remote monitoring).
  2. Select Download to get the extension ZIP file. Don't rename the file.
  3. Unzip the ZIP file to the plugin_deployment directory of your ActiveGate host. If the resulting directory structure isn't 
    .\plugin_deployment\<EXTENSION-SPECIFIC-DIRECTORY>\
    where <EXTENSION-SPECIFIC-DIRECTORY> is the name of the directory containing the files for this extension, make the necessary changes.
  4. In Dynatrace, go to Settings > Monitoring > Monitored technologies.
  5. Select Add new technology monitoring > Add ActiveGate extension.
  6. Select Upload extension and upload the ZIP file.
  7. After you upload the extension, go to Settings > Monitoring > Monitored technologies > Custom extensions.
  8. Find the extension and select it to open it for Endpoint configuration.
  9. 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