MySQL integration metrics
The official Datadog integration for monitoring MySQL. It collects 255 metrics.
Official summary
Collect performance schema metrics, query throughput, custom metrics, and more.
Metric types
- gauge (value at a point in time): 220
- count (occurrences in the interval): 35
Metrics
Descriptions are the official definitions, unedited.
| Metric | Type | Unit |
|---|---|---|
mysql.The number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction. | gauge | transaction |
mysql.The number of transactions that used the binary log cache. | gauge | transaction |
mysql.Total binary log file size. | gauge | byte |
mysql.Shows the average distance between the lowest and highest sequence number, or seqno, values that the node can possibly apply in parallel. | gauge | - |
mysql.The current number of nodes in the Galera cluster. | gauge | node |
mysql.Shows the fraction of the time, since FLUSH STATUS was last called, that the node paused due to Flow Control. | gauge | fraction |
mysql.Shows the pause time due to Flow Control, in nanoseconds. | count | nanosecond |
mysql.Shows the number of times the galera node has received a pausing Flow Control message from others | count | - |
mysql.Shows the number of times the galera node has sent a pausing Flow Control message to others | count | - |
mysql.Total number of local transactions that failed certification test. | count | - |
mysql.Shows the current (instantaneous) size of the local received queue. | gauge | - |
mysql.Shows the average size of the local received queue since the last FLUSH STATUS query. | gauge | - |
mysql.Show the current (instantaneous) size of the send queue length since the last FLUSH STATUS query. | gauge | - |
mysql.Show an average for the send queue length since the last FLUSH STATUS query. | gauge | - |
mysql.Internal Galera cluster state number | gauge | - |
mysql.Total number of write-sets received from other nodes. | gauge | - |
mysql.Total size (in bytes) of writesets received from other nodes. | gauge | - |
mysql.Total size (in bytes) of writesets sent to other nodes. | gauge | - |
mysql.The number of delete operations using an index. Resets to 0 upon database restart. | count | operation |
mysql.The number of read operations using an index. Resets to 0 upon database restart. | count | operation |
mysql.Size of index in bytes | gauge | byte |
mysql.The number of update operations using an index. Resets to 0 upon database restart. | count | operation |
mysql.Size of schemas in MiB | gauge | mebibyte |
mysql.Size of tables data in MiB | gauge | mebibyte |
mysql.Size of tables index in MiB | gauge | mebibyte |
mysql.Total number of rows changed per table (Percona userstat only) | count | row |
mysql.Total number of rows read per table (Percona userstat only) | count | row |
mysql.The number of active transactions on InnoDB tables. | gauge | operation |
mysql.The total number of bytes in the InnoDB buffer pool containing data. The number includes both dirty and clean pages. | gauge | byte |
mysql.The total current number of bytes held in dirty pages in the InnoDB buffer pool. | gauge | byte |
mysql.The number of free bytes in the InnoDB Buffer Pool. | gauge | byte |
mysql.The number of pages in the InnoDB buffer pool containing data. The number includes both dirty and clean pages. | gauge | page |
mysql.The current number of dirty pages in the InnoDB buffer pool. | gauge | page |
mysql.The number of requests to flush pages from the InnoDB buffer pool. | gauge | page/ |
mysql.The number of free pages in the InnoDB buffer pool. | gauge | page |
mysql.The total size of the InnoDB buffer pool, in pages. | gauge | page |
mysql.The number of pages read into the InnoDB buffer pool by the read-ahead background thread. | gauge | page/ |
mysql.The number of pages read into the InnoDB buffer pool by the read-ahead background thread that were subsequently evicted without having been accessed by queries. | gauge | page/ |
mysql.The number of random read-aheads initiated by InnoDB. This happens when a query scans a large portion of a table but in random order. | gauge | operation |
mysql.The number of logical read requests. | gauge | read/ |
mysql.The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk. | gauge | read/ |
mysql.The total number of bytes in the InnoDB Buffer Pool. | gauge | byte |
mysql.The number of used bytes in the InnoDB Buffer Pool. | gauge | byte |
mysql.The utilization of the InnoDB Buffer Pool. | gauge | fraction |
mysql.When InnoDB needs to read or create a page and no clean pages are available, InnoDB flushes some dirty pages first and waits for that operation to finish. This counter counts instances of these waits. | count | wait |
mysql.The number of writes done to the InnoDB buffer pool. | gauge | write/ |
mysql.Checkpoint age as shown in the LOG section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.The number of current row locks. | gauge | lock |
mysql.Current InnoDB transactions | gauge | transaction |
mysql.The number of fsync() operations per second. | gauge | operation/ |
mysql.The current number of pending fsync() operations. | gauge | operation |
mysql.The current number of pending reads. | gauge | read |
mysql.The current number of pending writes. | gauge | write |
mysql.The amount of data read per second. | gauge | byte/ |
mysql.The rate of data reads. | gauge | read/ |
mysql.The rate of data writes. | gauge | write/ |
mysql.The amount of data written per second. | gauge | byte/ |
mysql.The number of pages written per second to the doublewrite buffer. | gauge | page/ |
mysql.The number of doublewrite operations performed per second. | gauge | byte/ |
mysql.The number of deadlocks. | count | lock |
mysql.Total number of cells of the adaptive hash index | gauge | - |
mysql.Number of used cells of the adaptive hash index | gauge | - |
mysql.History list length as shown in the TRANSACTIONS section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.Insert buffer free list, as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.Insert buffer and adaptative hash index merged | gauge | operation |
mysql.Insert buffer and adaptative hash index merged delete marks | gauge | operation |
mysql.Insert buffer and adaptative hash index merged delete | gauge | operation |
mysql.Insert buffer and adaptative hash index merged inserts | gauge | operation |
mysql.Insert buffer and adaptative hash index merges | gauge | operation |
mysql.Insert buffer segment size, as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.Insert buffer size, as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.Lock structs | gauge | operation |
mysql.Locked tables | gauge | operation |
mysql.The number of times that the log buffer was too small and a wait was required for it to be flushed before continuing. | gauge | wait/ |
mysql.The number of write requests for the InnoDB redo log. | gauge | write/ |
mysql.The number of physical writes to the InnoDB redo log file. | gauge | write/ |
mysql.Log sequence number as shown in the LOG section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.Flushed up to log sequence number as shown in the LOG section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.Log sequence number last checkpoint as shown in the LOG section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output. | gauge | byte |
mysql.As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output. Only available in MySQL 5.6. | gauge | byte |
mysql.As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output. | gauge | byte |
mysql.As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output. | gauge | byte |
mysql.The rate of mutex OS waits. Only available in MySQL 5.6 and 5.7. | gauge | event/ |
mysql.The rate of mutex spin rounds. Only available in MySQL 5.6 and 5.7. | gauge | event/ |
mysql.The rate of mutex spin waits. Only available in MySQL 5.6 and 5.7. | gauge | event/ |
mysql.(Delta) The total number of fsync() operations performed by InnoDB. | gauge | operation |
mysql.(Delta) The total number of files reads performed by read threads within InnoDB. | gauge | operation |
mysql.(Delta) The total number of file writes performed by write threads within InnoDB. | gauge | operation |
mysql.The rate of fsync writes to the log file. | gauge | write/ |
mysql.Number of pending InnoDB log fsync (sync-to-disk) requests. | gauge | operation |
mysql.Number of pending InnoDB log writes. | gauge | write |
mysql.Number of bytes written to the InnoDB log. | gauge | byte/ |
mysql.Number of InnoDB pages created. | gauge | page/ |
mysql.Number of InnoDB pages read. | gauge | page/ |
mysql.Number of InnoDB pages written. | gauge | page/ |
mysql.As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output. | gauge | flush |
mysql.As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output. Only available in MySQL 5.6 and 5.7. | gauge | flush |
mysql.As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output. Only available in MySQL 5.6 and 5.7. | gauge | write |
mysql.As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output. | gauge | read |
mysql.As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output. | gauge | write |
mysql.As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output. | gauge | query |
mysql.As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output. | gauge | query |
mysql.As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.The number of row locks currently being waited for by operations on InnoDB tables. | gauge | - |
mysql.The time spent acquiring row locks. | gauge | millisecond |
mysql.The number of times per second a row lock had to be waited for. | gauge | event/ |
mysql.Number of rows deleted from InnoDB tables. | gauge | row/ |
mysql.Number of rows inserted into InnoDB tables. | gauge | row/ |
mysql.Number of rows read from InnoDB tables. | gauge | row/ |
mysql.Number of rows updated in InnoDB tables. | gauge | row/ |
mysql.As shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output | gauge | / |
mysql.As shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output. | gauge | / |
mysql.As shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output. | gauge | wait/ |
mysql.Semaphore wait time | gauge | - |
mysql.The number semaphore currently being waited for by operations on InnoDB tables. | gauge | - |
mysql.Tables in use | gauge | operation |
mysql.As shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output. | gauge | wait/ |
mysql.As shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output. | gauge | - |
mysql.As shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output. | gauge | wait |
mysql.MyISAM key buffer bytes unflushed. | gauge | byte |
mysql.MyISAM key buffer bytes used. | gauge | byte |
mysql.Size of the buffer used for index blocks. | gauge | byte |
mysql.The number of requests to read a key block from the MyISAM key cache. | gauge | read/ |
mysql.The number of physical reads of a key block from disk into the MyISAM key cache. If key_reads is large, then your key_buffer_size value is probably too small. The cache miss rate can be calculated as key_reads/key_read_requests. | gauge | read/ |
mysql.The number of requests to write a key block to the MyISAM key cache. | gauge | write/ |
mysql.The number of physical writes of a key block from the MyISAM key cache to disk. | gauge | write/ |
mysql.The number of connections that were aborted because the client died without closing the connection properly. | gauge | connection/ |
mysql.The number of failed attempts to connect to the MySQL server. | gauge | connection/ |
mysql.The rate of connections to the server. | gauge | connection/ |
mysql.The maximum number of connections that have been in use simultaneously since the server started. | gauge | connection |
mysql.The maximum permitted number of simultaneous client connections. | gauge | connection |
mysql.The number of bytes received from all clients. | gauge | byte/ |
mysql.The number of bytes sent to all clients. | gauge | byte/ |
mysql.The rate of delete statements. | gauge | query/ |
mysql.The rate of delete-multi statements. | gauge | query/ |
mysql.The rate of insert statements. | gauge | query/ |
mysql.The rate of insert-select statements. | gauge | query/ |
mysql.The rate of load statements. | gauge | query/ |
mysql.The rate of replace statements. | gauge | query/ |
mysql.The rate of replace-select statements. | gauge | query/ |
mysql.The rate of select statements. | gauge | query/ |
mysql.The rate of update statements. | gauge | query/ |
mysql.The rate of update-multi. | gauge | query/ |
mysql.Percentage of CPU time spent by MySQL. | gauge | percent |
mysql.The rate of internal on-disk temporary tables created by second by the server while executing statements. | gauge | table/ |
mysql.The rate of temporary files created by second. | gauge | file/ |
mysql.The rate of internal temporary tables created by second by the server while executing statements. | gauge | table/ |
mysql.Query response time 95th percentile per schema. | gauge | microsecond |
mysql.The number of errors raised per error code and name. Tags: error_number, error_name (DBM only) | count | error |
mysql.The number of internal COMMIT statements. | gauge | operation/ |
mysql.The number of internal DELETE statements. | gauge | operation/ |
mysql.The number of internal PREPARE statements. | gauge | operation/ |
mysql.The number of internal READ_FIRST statements. | gauge | operation/ |
mysql.The number of internal READ_KEY statements. | gauge | operation/ |
mysql.The number of internal READ_NEXT statements. | gauge | operation/ |
mysql.The number of internal READ_PREV statements. | gauge | operation/ |
mysql.The number of internal READ_RND statements. | gauge | operation/ |
mysql.The number of internal READ_RND_NEXT statements. | gauge | operation/ |
mysql.The number of internal ROLLBACK statements. | gauge | operation/ |
mysql.The number of internal UPDATE statements. | gauge | operation/ |
mysql.The number of internal WRITE statements. | gauge | operation/ |
mysql.Percentage of CPU time spent in kernel space by MySQL. | gauge | percent |
mysql.The key cache utilization ratio. | gauge | fraction |
mysql.The maximum allowed prepared statements on the server. | gauge | - |
mysql.The number of open files. | gauge | file |
mysql.The number of of tables that are open. | gauge | table |
mysql.The number of tables that have been opened. If opened_tables is big, your table_open_cache value is probably too small. | gauge | table/ |
mysql.The number of digest instances that could not be instrumented in the events_statements_summary_by_digest table. This can be nonzero if the value of performance_schema_digests_size is too small. | gauge | - |
mysql.The current number of prepared statements. | gauge | query/ |
mysql.Percentage of queries served from query cache since server start. | gauge | percent |
mysql.Percentage of queries served from query cache since last check. | gauge | percent |
mysql.The number of free memory blocks in the query cache. | gauge | block |
mysql.The amount of free memory for the query cache. | gauge | byte |
mysql.The rate of query cache hits. | gauge | hit/ |
mysql.The number of queries added to the query cache. | gauge | query/ |
mysql.The number of queries that were deleted from the query cache because of low memory. | gauge | query/ |
mysql.The number of noncached queries (not cacheable, or not cached due to the query_cache_type setting). | gauge | query/ |
mysql.The number of queries registered in the query cache. | gauge | query |
mysql.The amount of memory allocated for caching query results. | gauge | byte |
mysql.The total number of blocks in the query cache. | gauge | block |
mysql.The rate of queries. | gauge | query/ |
mysql.Avg query response time per schema. | gauge | microsecond |
mysql.The rate of statements executed by the server. | gauge | query/ |
mysql.The number of joins that perform table scans because they do not use indexes. If this value is not 0, you should carefully check the indexes of your tables. | gauge | operation/ |
mysql.The number of joins that used a range search on a reference table. | gauge | operation/ |
mysql.The number of joins that used ranges on the first table. This is normally not a critical issue even if the value is quite large. | gauge | operation/ |
mysql.The number of joins without keys that check for key usage after each row. If this is not 0, you should carefully check the indexes of your tables. | gauge | operation/ |
mysql.The number of joins that did a full scan of the first table. | gauge | operation/ |
mysql.The rate of slow queries (log queries that exceed a particular execution time). | gauge | query/ |
mysql.The number of merge passes that the sort algorithm has had to do. If this value is large, you should consider increasing the value of the sort_buffer_size system variable. | gauge | operation/ |
mysql.The number of sorts that were done using ranges. | gauge | operation/ |
mysql.The number of sorted rows. | gauge | operation/ |
mysql.The number of sorts that were done by scanning the table. | gauge | operation/ |
mysql.The number of hits for open tables cache lookups. | gauge | hit/ |
mysql.The number of misses for open tables cache lookups. | gauge | miss/ |
mysql.The number of times that a request for a table lock could be granted immediately. | gauge | - |
mysql.The rate of times that a request for a table lock could be granted immediately. | gauge | - |
mysql.The total number of times that a request for a table lock could not be granted immediately and a wait was needed. | gauge | - |
mysql.The rate of times that a request for a table lock could not be granted immediately and a wait was needed. | gauge | - |
mysql.The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires. | gauge | - |
mysql.How many threads the server should cache for reuse. When a client disconnects, the client's threads are put in the cache if there are fewer than thread_cache_size threads there. | gauge | byte |
mysql.The number of threads in the thread cache. | gauge | thread |
mysql.The number of currently open connections. | gauge | connection |
mysql.The number of threads created to handle connections. If threads_created is big, you may want to increase the thread_cache_size value. | count | thread |
mysql.The number of threads that are not sleeping. | gauge | thread |
mysql.The number of user connections. Tags: processlist_db, processlist_host, processlist_state, processlist_user | gauge | connection |
mysql.Percentage of CPU time spent in user space by MySQL. | gauge | percent |
mysql.Average wait time per occurrence of a wait event (DBM only). Tagged by wait_event. | gauge | nanosecond |
mysql.Total number of occurrences of a wait event (DBM only). Tagged by wait_event. | count | event |
mysql.Maximum single-occurrence wait time for a wait event (DBM only). Tagged by wait_event. | gauge | nanosecond |
mysql.Total accumulated wait time for a wait event (DBM only). Tagged by wait_event. | count | nanosecond |
mysql.The total count of executed queries per normalized query and schema. (DBM only) | count | query |
mysql.The total count of temporary tables that exceeded tmp_table_size and were written to disk per normalized query and schema. (DBM only) | count | table |
mysql.The total count of in-memory temporary tables created during execution per normalized query and schema. (DBM only) | count | table |
mysql.The total count of queries run with an error per normalized query and schema. (DBM only) | count | error |
mysql.The total time spent waiting on locks per normalized query and schema. (DBM only) | count | nanosecond |
mysql.The total count of queries which used a sub-optimal index per normalized query and schema. (DBM only) | count | query |
mysql.The total count of queries which do not use an index per normalized query and schema. (DBM only) | count | query |
mysql.The number of rows mutated per normalized query and schema. (DBM only) | count | row |
mysql.The number of rows examined per normalized query and schema. (DBM only) | count | row |
mysql.The number of rows sent per normalized query and schema. (DBM only) | count | row |
mysql.The total count of full table scans on a joined table per normalized query and schema. (DBM only) | count | - |
mysql.The total count of joins that used a range search on a referenced table per normalized query and schema. (DBM only) | count | operation |
mysql.The total count of joins that used a range on the first table per normalized query and schema. (DBM only) | count | operation |
mysql.The total count of joins where the optimizer re-evaluates index usefulness per row per normalized query and schema. (DBM only) | count | operation |
mysql.The total count of full table scans on the first table per normalized query and schema. (DBM only) | count | - |
mysql.The total count of multi-pass sort operations that spilled to disk per normalized query and schema. (DBM only) | count | operation |
mysql.The total count of sorts performed using an index range per normalized query and schema. (DBM only) | count | operation |
mysql.The total number of rows sorted per normalized query and schema. (DBM only) | count | row |
mysql.The total count of sorts performed via full table scan per normalized query and schema. (DBM only) | count | operation |
mysql.The total query execution time per normalized query and schema. (DBM only) | count | nanosecond |
mysql.The number of transactions that have not passed the conflict detection check. | gauge | transaction |
mysql.Information about the node status in a group replication environment, always equal to 1. | gauge | - |
mysql.The number of transactions in the queue pending conflict detection checks. | gauge | transaction |
mysql.Number of transactions this member has received from the group and applied. | gauge | transaction |
mysql.The number of transactions that have been checked for conflicts. | gauge | transaction |
mysql.The number of transactions that this member has received from the replication group which are waiting to be applied. | gauge | transaction |
mysql.The number of transactions which originated on this member and were sent to the group. | gauge | transaction |
mysql.The number of transactions which originated on this member and were rolled back by the group. | gauge | transaction |
mysql.The number of transaction rows which can be used for certification, but have not been garbage collected. | gauge | transaction |
mysql.Number of replicas connected to a replication source. | gauge | - |
mysql.The lag in seconds between the master and the slave. | gauge | second |
mysql.The lag in seconds between the source and the replica. | gauge | second |
mysql.Deprecated. Use service check mysql.replication.replica_running instead. A boolean showing if this server is a replication slave / master that is running. | gauge | - |
mysql.Deprecated. Use mysql.replication.replicas_connected instead. Number of slaves connected to a replication master. | gauge | - |
mysql.The number of seconds that the server has been up. | gauge | second |
Official documentation
Metric names and descriptions are the official Datadog integration definitions (Copyright Datadog, Inc., BSD-3-Clause), reproduced unedited. The full license terms are on the About page.