Dynatrace Hub

Extend the platform,
empower your team.

Popular searches:

Home hero bg

MySQL (remote monitoring)

Remotely monitor your MySQL instances, collect key KPIs and slow queries details

Extension by Dynatrace

Free trial Documentation

Overview dashboard

Host screen injection

Instance details

Product information
Release notes

Overview

Remotely monitor MySQL databases where you cannot install an OneAgent.

Get started

Activating the extension

Activate Extension in the Hub by going to:
Extensions → MySQL → Add to environment
Add a new monitoring configuration for every MySQL instance you'd like to monitor

Creating a MySQL user

Create a user that is identified by a native password, customize the username and password as you please

CREATE USER 'dynatrace'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

Give the user the permissions:

GRANT SELECT ON performance_schema.* TO 'dynatrace'@'%';
- Allows the user to query the performance_schema schema
GRANT PROCESS ON *.* TO 'dynatrace'@'%';
- Allows the user to see thread and connection metrics for other users
GRANT SHOW DATABASES ON *.* TO 'dynatrace'@'%';
- Allows the user to see database metrics for all databases
GRANT SELECT ON mysql.slow_log TO 'dynatrace'@'%';
- Allows the user to query slow queries
GRANT SELECT ON sys.x$memory_global_by_current_bytes TO 'dynatrace'@'%';
- Allow the user to query memory statistics

Collecting Infrastructure metrics

To enable CPU metrics collection, run this query on the MySQL instance:

SET GLOBAL innodb_monitor_enable='cpu%';

Collecting Top Slow Queries

Enable slow queries logging to a table:

SET GLOBAL log_output = 'TABLE';
SET GLOBAL slow_query_log = 'ON';

The default slow query threshold is 10 seconds You can chose the threshold of what is a "slow query" by executing:

SET GLOBAL long_query_time = 2;

This would set slow queries threshold to 2 seconds.

Compatibility information

MySQL >= 5.7

FAQ

Why don't I see Waits metrics?

To gather wait metrics, data collection need to be enabled for the MySQL instance, please refer to the documentation: https://dev.mysql.com/doc/mysql-perfschema-excerpt/8.0/en/performance-schema-wait-tables.html

Can I monitor MariaDB with this extension?

This extension was only tested against MySQL instances, MariaDB is not officially supported via this extension.

I get an error "RSA public key is not available client side"

This means that the username is not identified by a native password, please refer to Get Started.

I can't see CPU and Memory metrics

Make sure that data collection is enabled for your instance.

For CPU: SET GLOBAL innodb_monitor_enable='cpu%';
For Memory: Visit https://dev.mysql.com/doc/refman/8.0/en/monitor-mysql-memory-use.html

You can test that you can query the data by running:

SELECT * FROM information_schema.INNODB_METRICS WHERE name IN ('cpu_utime_abs', 'cpu_stime_abs');

And:

SELECT SUBSTRING_INDEX(event_name,'/',2) AS code_area,
                SUM(current_alloc) AS current_alloc
          FROM sys.x$memory_global_by_current_bytes
          GROUP BY SUBSTRING_INDEX(event_name,'/',2)
          ORDER BY SUM(current_alloc) DESC;

I can't see slow queries

Refer to the Collecting Top Slow Queries in the Getting Started session.

Resources

Support

Built and supported by Dynatrace

Dynatrace support center

Subscribe to new releases

copy to clipboard

Extension content

Content typeNumber of items included

screen injections

1

screen logs cards

2

screen properties

2

screen layout

2

generic relationship

2

metric metadata

32

screen chart groups

6

dashboards

1

list screen layout

1

screen entities lists

2

generic type

2

Feature sets

Below is a complete list of the feature sets provided in this version. To ensure a good fit for your needs, individual metrics can be activated and deactivated by your administrator during configuration.

Feature setsNumber of metrics included

Metric name	Metric key	Description	Unit
Commits	mysql.statements.commit.count	The number of COMMIT statements executed by this server	Count
Deletes	mysql.statements.delete.count	The number of DELETE statements executed by this server	Count
Multi-Table Deletes	mysql.statements.delete_multi.count	The number of multi-table DELETE statements executed by this server	Count
Inserts	mysql.statements.insert.count	The number of INSERT statements executed by this server	Count
Selects	mysql.statements.select.count	The number of SELECT statements executed by this server	Count
Updates	mysql.statements.update.count	The number of UPDATE statements executed by this server	Count
Executes	mysql.statements.execute.count	The number of EXECUTE statements executed by this server	Count
Multi-Table Updates	mysql.statements.update_multi.count	The number of multi-table UPDATE statements executed by this server	Count
Bytes Sent	mysql.statements.bytes_sent.count	The number of bytes sent to all clients	Byte
Bytes Received	mysql.statements.bytes_received.count	The number of bytes received from all clients	Byte

Metric name	Metric key	Description	Unit
Waits IO	mysql.waits.waits_io.count	The number of times that the server has waited for an I/O operation to complete.	Count
Waits IO Time	mysql.waits.waits_io_time.count	The total time the server has waited for I/O operations to complete.	MilliSecond
Waits Sync	mysql.waits.waits_sync.count	The number of times that the server has waited for a synchronization operation to complete.	Count
Waits Sync Time	mysql.waits.waits_sync_time.count	The total time the server has waited for synchronization operations to complete.	MilliSecond

No matching metrics...

Metric name	Metric key	Description	Unit
Database Size	mysql.databases.size	The size of the Database	MegaByte

Metric name	Metric key	Description	Unit
CPU User	mysql.infrastructure.cpu.user	The total CPU time spent in user mode.	Percent
CPU System	mysql.infrastructure.cpu.system	The total CPU time spent in system mode.	Percent
Memory	mysql.infrastructure.memory	The amount of memory used per each code area.	Byte

Metric name	Metric key	Description	Unit
Queries	mysql.global_status.queries.count	The number of queries executed by this server	Count
Slow Queries	mysql.global_status.slow_queries.count	The number of queries that have taken more than long_query_time seconds. This counter increments regardless of whether the slow query log is enabled. For information about that log, see Section 5.4.5, “The Slow Query Log”.	Count
Table Locks Waited	mysql.global_status.table_locks_waited.count	The number of times that a request for a table lock could not be granted immediately and a wait was needed. If this is high and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication.	Count
Table Locks Immediate	mysql.global_status.table_locks_immediate.count	The number of times that a request for a table lock could be granted immediately.	Count
Current Connections	mysql.global_status.current_connections	The number of currently open connections.	Count
Threads Running	mysql.global_status.threads_running	The number of threads that are not sleeping.	Count
Innodb Buffer Pool Pages Data	mysql.global_status.innodb_buffer_pool_pages_data	The number of pages in the InnoDB buffer pool containing data. The number includes both dirty and clean pages. When using compressed tables, the reported Innodb_buffer_pool_pages_data value may be larger than Innodb_buffer_pool_pages_total	Count
Innodb Buffer Pool Pages Dirty	mysql.global_status.innodb_buffer_pool_pages_dirty	The current number of dirty pages in the InnoDB buffer pool.	Count
Innodb Buffer Pool Pages Free	mysql.global_status.innodb_buffer_pool_pages_free	The number of free pages in the InnoDB buffer pool.	Count
Innodb Buffer Pool Pages Total	mysql.global_status.innodb_buffer_pool_pages_total	The total size of the InnoDB buffer pool, in pages. When using compressed tables, the reported Innodb_buffer_pool_pages_data value may be larger than Innodb_buffer_pool_pages_total	Count
Innodb Data Reads	mysql.global_status.innodb_data_reads.count	The total number of data reads (OS file reads).	Count
Innodb Data Writes	mysql.global_status.innodb_data_writes.count	The total number of data writes.	Count
Innodb Data Read	mysql.global_status.innodb_data_read.count	The total amount of data read from files.	Byte
Innodb Data Written	mysql.global_status.innodb_data_written.count	The total amount of data written.	Byte

Related to MySQL (remote monitoring)

ActiveGate

Route traffic, monitor cloud environments, monitor remote technologies with extensions and run synthetic monitors.

Full version history

To have more information on how to install the downloaded package, please follow the instructions on this page.

ReleaseDate

Version 1.1.1

Fix an issue where MySQL entities were created from unrelated logs

Version 1.1.0

Add CPU metrics
Add Memory metrics
Add Slow Queries (log events)

Version 1.0.0

First release, instance and database metrics

Dynatrace Hub

Build your own app

All (668)Log Management and Analytics Kubernetes Infrastructure Observability Automations Application Observability Application Security Digital Experience Business Analytics

Dynatrace Developer

Discover recent additions to Dynatrace

Site Reliability Guardian

Get automated change impact analysis for release and change validation.

DevSecOps Lifecycle Coverage with Snyk

Connect Snyk container scans and Dynatrace runtime insights for strong security.

Business Flow

Track, analyze, and optimize your critical business processes.

Salesforce Insights

Monitor Salesforce performance, user experience, adoption, and threats.

Carbon Impact

Track, analyze and reduce the carbon footprint of your hybrid cloud environment.

Analyze your data

Understand your data better with deep insights and clear visualizations.

Notebooks

Create powerful, data-driven documents for custom analytics and collaboration.

Dashboards

Transform complex data into clear visualizations with custom dashboards.

Automate your processes

Turn data and answers into actions, securely, and at scale.

Workflows

Automate tasks in your IT landscape, remediate problems, and visualize processes

Jira for Workflows

Create, query, comment on, and resolve Jira tickets within your workflows.

Slack for Workflows

Automate Slack messaging for security incidents, attacks, remediation, and more.

Secure your cloud application

See vulnerabilities and attacks in your environment.

Security overview

Get a comprehensive overview of the security of your applications.

Third-party vulnerabilities

Detect vulnerabilities in real time, with context and automated risk assessment.

Code-level vulnerabilities

Detect vulnerabilities in your code in real time.

Attacks

Get a real-time overview of all the attacks on your environment.

Are you looking for something different?We have hundred of apps, extensions, and other technologies to customize your environment

Leverage our newest innovations of Dynatrace Saas

Kick-start your app creation

Kick-start your app creation

Whether you’re a beginner or a pro, Dynatrace Developer has the tools and support you need to create incredible apps with minimal effort.

Go to Dynatrace Developer

Upgrading from Dynatrace Managed to SaaS

Upgrading from Dynatrace Managed to SaaS

Drive innovation, speed, and agility in your organization by seamlessly and securely upgrading.

Log Management and Analytics

Log Management and Analytics

Innovate faster and more efficiently with unified log management and log analytics for actionable insights and automation.