Remotely monitor your MySQL instances, collect connections, statements, throughput, waits, database metrics.
Remotely monitor MySQL databases where you cannot install an OneAgent.
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'@'%';
GRANT PROCESS ON *.* TO 'dynatrace'@'%';
GRANT SHOW DATABASES ON *.* TO 'dynatrace'@'%';
Ensure that you have log monitoring enabled to get full log insight.
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
This extension was only tested against MySQL instances, MariaDB is not officially supported via this extension.
This means that the username is not identified by a native password, please refer to Get Started.
|Database Size||mysql.databases.size||MegaByte||The size of the Database|
|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.|
|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.|
|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|
Extend the platform,
empower your team.