MySQL (remote monitoring)

Supported by Dynatrace

Remotely monitor your MySQL instances, collect connections, statements, throughput, waits, database metrics.

Remotely monitor MySQL databases where you cannot install an OneAgent.

Compatibility information

MySQL >= 5.7

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

Ensure that you have log monitoring enabled to get full log insight.

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.

Metrics

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

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

Name	Metric key	Unit	Description
Queries	mysql.global_status.queries.count	Count	The number of queries executed by this server
Slow Queries	mysql.global_status.slow_queries.count	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”.
Table Locks Waited	mysql.global_status.table_locks_waited.count	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.
Table Locks Immediate	mysql.global_status.table_locks_immediate.count	Count	The number of times that a request for a table lock could be granted immediately.
Current Connections	mysql.global_status.current_connections	Count	The number of currently open connections.
Threads Running	mysql.global_status.threads_running	Count	The number of threads that are not sleeping.
Innodb Buffer Pool Pages Data	mysql.global_status.innodb_buffer_pool_pages_data	Count	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
Innodb Buffer Pool Pages Dirty	mysql.global_status.innodb_buffer_pool_pages_dirty	Count	The current number of dirty pages in the InnoDB buffer pool.
Innodb Buffer Pool Pages Free	mysql.global_status.innodb_buffer_pool_pages_free	Count	The number of free pages in the InnoDB buffer pool.
Innodb Buffer Pool Pages Total	mysql.global_status.innodb_buffer_pool_pages_total	Count	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
Innodb Data Reads	mysql.global_status.innodb_data_reads.count	Count	The total number of data reads (OS file reads).
Innodb Data Writes	mysql.global_status.innodb_data_writes.count	Count	The total number of data writes.
Innodb Data Read	mysql.global_status.innodb_data_read.count	Byte	The total amount of data read from files.
Innodb Data Written	mysql.global_status.innodb_data_written.count	Byte	The total amount of data written.

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