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