MySQL monitoring integration
MySQL integration with New Relic equips your team to monitor, analyze, and optimize database performance effectively. By leveraging comprehensive insights and proactive management capabilities, you can enhance the reliability and efficiency of your MySQL databases, ultimately improving application performance and user satisfaction.
This guide provides detailed instructions to install and configure the New Relic MySQL integration to monitor and analyze MySQL database performance. Additionally, this guide also includes instructions to and configure the New Relic MySQL integration for query-level insights. For more information, refer to Query-Level monitoring.
Metrics collected by the integration
The MySQL integration collects the following metrics:
These metrics are captured by default.
Event Attribute Name | Dimensional Metric Name | Description |
|---|---|---|
|
| Boolean. |
|
| Rate of requests for a storage engine to perform a rollback operation, per second. |
|
| Number of pages in the InnoDB buffer pool containing data. |
|
| Number of free pages in the InnoDB buffer pool. |
|
| Total number of pages of the InnoDB buffer pool. |
|
| Rate at which data is read from InnoDB tables in bytes per second. |
|
| Rate at which data is written to InnoDB tables in bytes per second. |
|
| Number of times that the log buffer was too small and a wait was required for it to be flushed before continuing, in waits per second. |
|
| Number of row locks currently being waited for by operations on InnoDB tables. |
|
| Average time to acquire a row lock for InnoDB tables, in milliseconds. |
|
| Number of times operations on InnoDB tables had to wait for a row lock per second. |
|
| Number of files that have been opened with |
|
| Number of files that are open. This count includes regular files opened by the server. It does not include other types of files such as sockets or pipes. |
|
| Number of tables that are open. |
|
| Amount of free memory in bytes for the query cache. Not supported from MySQL 8.0 |
|
| Percentage of queries that are retrieved from the cache. Not supported from MySQL 8.0 |
|
| Number of noncached queries (not cacheable, or not cached due to the |
|
| Percentage of query cache memory that is being used. Not supported from MySQL 8.0 |
|
| Number of times per second that a request for a table lock could not be granted immediately and a wait was needed. |
|
| Number of connections per second that were aborted because the client died without closing the connection properly. |
|
| Number of failed attempts to connect to the MySQL server, per second. |
|
| Byte throughput received from all clients, per second. |
|
| Byte throughput sent to all clients, per second. |
|
| Rate per second at which connections were refused because the server |
|
| Number of connection attempts per second. |
|
| Maximum number of connections that have been in use simultaneously since the server started. |
|
| Number of currently open connections. |
|
| Number of threads that are not sleeping. |
|
| Number of COMMIT statements executed per second. |
|
| Number of DELETE statements executed per second. |
|
| Number of DELETE statements that use the multiple-table syntax executed per second. |
|
| Number of INSERT statements executed per second. |
|
| Number of INSERT SELECT statements executed per second. |
|
| Number of REPLACE SELECT statements executed per second. |
|
| Number of ROLLBACK statements executed per second. |
|
| Number of SELECT statements executed per second. |
|
| Number of UPDATE statements that use the multiple-table syntax executed per second. |
|
| Number of UPDATE statements executed per second. |
|
| Current number of prepared statements per second. (The maximum number of statements is given by the |
|
| Total number of statements executed by the server per second, including statements executed within stored programs. |
|
| Number of statements executed by the server per second, limited to only those sent by clients. |
|
| Number of queries per second that have taken more than |
Additional metrics captured when extended_metrics is enabled, that is, set to 1 in the configuration file:
Event Attribute Name | Dimensional Metric Name | Description |
|---|---|---|
|
| Number of internal on-disk temporary tables created per second by the server while executing statements. |
|
| Number of temporary files created per second by mysqld. |
|
| Number of internal temporary tables created per second by the server while executing statements. |
|
| Number of times per second that rows have been deleted from tables. |
|
| Number of times per second the first entry in an index was read. |
|
| Number of requests per second to read a row based on a key. |
|
| Number of requests per second to read the next row in the data file. |
|
| Number of requests per second to read a row based on a fixed position. |
|
| Number of requests per second to update a row in a table. |
|
| Number of requests per second to insert a row in a table. |
|
| Number of SELECT statements per second for which the execution timeout was exceeded. |
|
| Number of free memory blocks in the query cache. Not supported from MySQL 8.0 |
|
| Number of query cache hits per second. Not supported from MySQL 8.0 |
|
| Number of queries added to the query cache. Not supported from MySQL 8.0 |
|
| Number of queries per second that were deleted from the query cache because of low memory. Not supported from MySQL 8.0 |
|
| Number of queries per second registered in the query cache. Not supported from MySQL 8.0 |
|
| Total number of blocks in the query cache. Not supported from MySQL 8.0 |
|
| Number of joins that perform table scans because they do not use indexes, per second. |
|
| Number of joins per second that used a range search on a reference table. |
|
| Number of joins per second without keys that check for key usage after each row. |
|
| Number of joins per second that used ranges on the first table. |
|
| Number of merge passes that the sort algorithm has had to do, per second. |
|
| Number of sorts per second that were done using ranges. |
|
| Number of sorted rows per second. |
|
| Number of sorts that were done by scanning the table, per second. |
|
| Number of hits per second for open tables cache lookups. |
|
| Number of misses per second for open tables cache lookups. |
|
| Number of overflows per second for the open tables cache. |
|
| Percent of threads that need to be created to handle new connections because there are not enough threads available in the cache. |
|
| Number of threads in the thread cache. |
|
| Number of threads per second created to handle connections. |
Additional metrics captured when extended_innodb_metrics is enabled, that is, set to 1 in the configuration file:
Event Attribute Name | Dimensional Metric Name | Description |
|---|---|---|
|
| Current number of dirty pages in the InnoDB buffer pool. |
|
| Number of requests per second to flush pages from the InnoDB buffer pool. |
|
| Number of pages per second read into the InnoDB buffer pool by the read-ahead background thread that were subsequently evicted without having been accessed by queries. |
|
| Number of pages per second read into the InnoDB buffer pool by the read-ahead background thread. |
|
| Number of “random” read-aheads per second initiated by InnoDB. This happens when a query scans a large portion of a table but in random order. |
|
| Number of logical read requests per second. |
|
| Number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk, per second. |
|
| Number of times per second a read or write to InnoDB had to wait because there were not clean pages available in the buffer pool. |
|
| Number of writes per second done to the InnoDB buffer pool. |
|
| Number of |
|
| Current number of pending fsync() operations. |
|
| Current number of pending reads. |
|
| Current number of pending writes. |
|
| Number of data reads (OS file reads) per second. |
|
| Number of data writes per second. |
|
| Number of write requests for the InnoDB redo log per second. |
|
| Number of physical writes per second to the InnoDB redo log file. |
|
| Number of files InnoDB currently holds open. |
|
| Number of |
|
| Number of pending |
|
| Number of pending writes per second to the InnoDB redo log files. |
|
| Number of bytes written per second to the InnoDB redo log files. |
|
| The number of pages created per second by operations on InnoDB tables. |
|
| Number of pages read per second from the InnoDB buffer pool by operations on InnoDB tables. |
|
| Number of pages written per second by operations on InnoDB tables. |
|
| Number of rows deleted per second from InnoDB tables. |
|
| Number of rows per second inserted into InnoDB tables. |
|
| Number of rows per second read from InnoDB tables. |
|
| Number of rows per second updated in InnoDB tables. |
Additional metrics captured when extended_myisam_metrics is enabled, that is, set to 1 in the configuration file:
Event Attribute Name | Dimensional Metric Name | Description |
|---|---|---|
|
| Number of key blocks in the MyISAM key cache that have changed but have not yet been flushed to disk. |
|
| Percentage of the key cache that is being used. |
|
| Number of requests to read a key block from the MyISAM key cache, per second. |
|
| Number of physical reads of a key block from disk into the MyISAM key cache, per second. |
|
| Number of requests per second to write a key block to the MyISAM key cache. |
|
| Number of physical writes of a key block from the MyISAM key cache to disk, per second. |
Additional metrics captured when the extended metrics flag is enabled in the configuration file and the cluster.slaveRunning metric is returning a value of 1. Check the MySQL Documentation for more details.
Event Attribute Name | Dimensional Metric Name | Description |
|---|---|---|
|
| Total combined number of bytes for all existing relay log files. |
|
| Error number of the most recent error that caused the I/O thread to stop. |
| N/A | Error message of the most recent error that caused the I/O thread to stop. |
|
| Error number of the most recent error that caused the SQL thread to stop. |
| N/A | Error message of the most recent error that caused the SQL thread to stop. |
| N/A | Status of whether the I/O thread is started and has connected successfully to the master. The values can be |
| N/A | Status of whether the SQL thread is started. The values can be |
|
| Difference in seconds between the slave’s clock time and the timestamp of the query when it was recorded in the master’s binary log. When the slave is not correctly connected to the master, this metric won’t be reported. |
| N/A | Name of the master binary log file from which the I/O thread is currently reading. |
|
| Position in the current master binary log file up to which the I/O thread has read. |
| N/A | Name of the master binary log file containing the most recent event executed by the SQL thread. |
|
| Position in the current master binary log file to which the SQL thread has read and executed, marking the start of the next transaction or event to be processed. |
Metrics collected by query performance monitoring
The MySQL Query Performance Monitoring collects the following metrics. The following metrics can be accessed via the MysqlSample event:
You can view the metrics for slow queries using MysqlSlowQueriesSample event.
Event Attribute Name | Description |
|---|---|
| Identifier for the slow query. The |
| Contains the normalized and anonymized version of the SQL query where literal values are replaced with placeholders. |
| The database the slow query was executed against. The |
| The schema the slow query was executed against. The |
| Number of times this slow query has been executed. The |
| Average CPU time in milliseconds spent executing this slow query. The |
| Average elapsed time in milliseconds to execute this slow query. The |
| Average number of disk reads performed by this slow query. The |
| Average number of disk writes performed by this slow query. The |
| Indicates whether the query performed a full table scan ("true" or "false"). The |
| The type of SQL statement (e.g., "SELECT", "INSERT", "UPDATE"). The |
| Timestamp of the last time this slow query was executed. The |
| Timestamp of the collection of this metrics data. The |
You can view the metrics for individual query executions using MysqlIndividualQueriesSample event.
Event Attribute Name | Description |
|---|---|
| Identifier for the query. The |
| Contains the anonymized version of the SQL query where literal values are replaced with placeholders. |
| Unique identifier for this query execution event. The |
| Identifier of the thread that executed the query. The |
| Execution time of the query in milliseconds. The |
| Number of rows sent by the query. The |
| Number of rows examined by the query. The |
| The database the query was executed against. The |
You can view the metrics for query plans using MysqlQueryExecutionSample event.
Event Attribute Name | Description |
|---|---|
| Unique identifier for the query execution event. The |
| Identifier of the thread that executed the query. The |
| Identifier for the step in the query plan. The |
| Estimated cost of the query. The |
| Name of the table involved in the query plan step. The |
| How the table was accessed (e.g., "ALL", "index", "range"). The |
| Number of rows examined per scan. The |
| Number of rows produced per join. The |
| Percentage of rows filtered after access. The |
| Estimated cost of reading data. The |
| Estimated cost of evaluating conditions. The |
| Possible keys for the table. The |
| Key actually used. The |
| Parts of the key used. The |
| Rows reference. The |
| Cost of running query before this step. The |
| Data read per join. The |
| Whether index is used. The |
| Length of the key used. The |
You can view the metrics for wait events using MysqlWaitEventsSample event.
Event Attribute Name | Description |
|---|---|
| Total wait time in milliseconds for this query. The |
| Identifier for the query. The |
| Contains the anonymized version of the SQL query where literal values are replaced with placeholders. |
| The database the query was executed against. The |
| Category of the wait event (e.g., "io", "lock"). The |
| Timestamp of the collection of this metrics data. The |
| Name of the specific wait event. The |
| Number of times this wait event occurred for this query. The |
| Average time spent waiting for this event. The |
You can view the metrics for blocking sessions using MysqlBlockingSessionSample event.
Event Attribute Name | Description |
|---|---|
| Transaction ID of the blocked session. The |
| Process ID of the blocked session. The |
| Thread ID of the blocked session. The |
| Query ID of the blocked session. The |
| Contains the anonymized version of the SQL query where literal values are replaced with placeholders. |
| Status of the blocked session. The |
| Host of the blocked session. The |
| The database the blocked session is connected to. The |
| Transaction ID of the blocking session. The |
| Process ID of the blocking session. The |
| Thread ID of the blocking session. The |
| Host of the blocking session. The |
| Query ID of the blocking session. The |
| Contains the anonymized version of the SQL query where literal values are replaced with placeholders. |
| Status of the blocking session. The |
| Time in milliseconds the blocked query has been running. The |
| Time in milliseconds the blocking query has been running. The |
| Timestamp when the blocked transaction started. The |
| Timestamp when the blocking transaction started. The |
| Timestamp of the collection of this metrics data. The |