﻿---
title: MySQL fields
description: MySQL server status metrics collected from MySQL. mysql contains the metrics that were obtained from MySQL query. galera_status contains the metrics that...
url: https://www.elastic.co/elastic/docs-builder/docs/2988/reference/beats/metricbeat/exported-fields-mysql
products:
  - Beats
  - Metricbeat
applies_to:
  - Elastic Cloud Serverless: Generally available
  - Elastic Stack: Generally available
---

# MySQL fields
MySQL server status metrics collected from MySQL.

## mysql

`mysql` contains the metrics that were obtained from MySQL query.

## galera_status

<applies-to>
  - Elastic Stack: Beta
</applies-to>

`galera_status` contains the metrics that were obtained by the status SQL query on Galera.

## apply

Apply status fields.
<definitions>
  <definition term="mysql.galera_status.apply.oooe">
    How often applier started write-set applying out-of-order (parallelization efficiency).
    type: double
  </definition>
  <definition term="mysql.galera_status.apply.oool">
    How often write-set was so slow to apply that write-set with higher seqno's were applied earlier. Values closer to 0 refer to a greater gap between slow and fast write-sets.
    type: double
  </definition>
  <definition term="mysql.galera_status.apply.window">
    Average distance between highest and lowest concurrently applied seqno.
    type: double
  </definition>
</definitions>


## cert

Certification status fields.
<definitions>
  <definition term="mysql.galera_status.cert.deps_distance">
    Average distance between highest and lowest seqno value that can be possibly applied in parallel (potential degree of parallelization).
    type: double
  </definition>
  <definition term="mysql.galera_status.cert.index_size">
    The number of entries in the certification index.
    type: long
  </definition>
  <definition term="mysql.galera_status.cert.interval">
    Average number of transactions received while a transaction replicates.
    type: double
  </definition>
</definitions>


## cluster

Cluster status fields.
<definitions>
  <definition term="mysql.galera_status.cluster.conf_id">
    Total number of cluster membership changes happened.
    type: long
  </definition>
  <definition term="mysql.galera_status.cluster.size">
    Current number of members in the cluster.
    type: long
  </definition>
  <definition term="mysql.galera_status.cluster.status">
    Status of this cluster component. That is, whether the node is part of a PRIMARY or NON_PRIMARY component.
    type: keyword
  </definition>
</definitions>


## commit

Commit status fields.
<definitions>
  <definition term="mysql.galera_status.commit.oooe">
    How often a transaction was committed out of order.
    type: double
  </definition>
  <definition term="mysql.galera_status.commit.window">
    Average distance between highest and lowest concurrently committed seqno.
    type: long
  </definition>
  <definition term="mysql.galera_status.connected">
    If the value is OFF, the node has not yet connected to any of the cluster components. This may be due to misconfiguration. Check the error log for proper diagnostics.
    type: keyword
  </definition>
</definitions>


## evs

Evs Fields.
<definitions>
  <definition term="mysql.galera_status.evs.evict">
    Lists the UUID's of all nodes evicted from the cluster. Evicted nodes cannot rejoin the cluster until you restart their mysqld processes.
    type: keyword
  </definition>
  <definition term="mysql.galera_status.evs.state">
    Shows the internal state of the EVS Protocol.
    type: keyword
  </definition>
</definitions>


## flow_ctl

Flow Control fields.
<definitions>
  <definition term="mysql.galera_status.flow_ctl.paused">
    The fraction of time since the last FLUSH STATUS command that replication was paused due to flow control. In other words, how much the slave lag is slowing down the cluster.
    type: double
  </definition>
  <definition term="mysql.galera_status.flow_ctl.paused_ns">
    The total time spent in a paused state measured in nanoseconds.
    type: long
  </definition>
  <definition term="mysql.galera_status.flow_ctl.recv">
    Returns the number of FC_PAUSE events the node has received, including those the node has sent. Unlike most status variables, the counter for this one does not reset every time you run the query.
    type: long
  </definition>
  <definition term="mysql.galera_status.flow_ctl.sent">
    Returns the number of FC_PAUSE events the node has sent. Unlike most status variables, the counter for this one does not reset every time you run the query.
    type: long
  </definition>
  <definition term="mysql.galera_status.last_committed">
    The sequence number, or seqno, of the last committed transaction.
    type: long
  </definition>
</definitions>


## local

Node specific Cluster status fields.
<definitions>
  <definition term="mysql.galera_status.local.bf_aborts">
    Total number of local transactions that were aborted by slave transactions while in execution.
    type: long
  </definition>
  <definition term="mysql.galera_status.local.cert_failures">
    Total number of local transactions that failed certification test.
    type: long
  </definition>
  <definition term="mysql.galera_status.local.commits">
    Total number of local transactions committed.
    type: long
  </definition>
</definitions>


## recv

Node specific recv fields.
<definitions>
  <definition term="mysql.galera_status.local.recv.queue">
    Current (instantaneous) length of the recv queue.
    type: long
  </definition>
  <definition term="mysql.galera_status.local.recv.queue_avg">
    Recv queue length averaged over interval since the last FLUSH STATUS command. Values considerably larger than 0.0 mean that the node cannot apply write-sets as fast as they are received and will generate a lot of replication throttling.
    type: double
  </definition>
  <definition term="mysql.galera_status.local.recv.queue_max">
    The maximum length of the recv queue since the last FLUSH STATUS command.
    type: long
  </definition>
  <definition term="mysql.galera_status.local.recv.queue_min">
    The minimum length of the recv queue since the last FLUSH STATUS command.
    type: long
  </definition>
  <definition term="mysql.galera_status.local.replays">
    Total number of transaction replays due to asymmetric lock granularity.
    type: long
  </definition>
</definitions>


## send

Node specific sent fields.
<definitions>
  <definition term="mysql.galera_status.local.send.queue">
    Current (instantaneous) length of the send queue.
    type: long
  </definition>
  <definition term="mysql.galera_status.local.send.queue_avg">
    Send queue length averaged over time since the last FLUSH STATUS command. Values considerably larger than 0.0 indicate replication throttling or network throughput issue.
    type: double
  </definition>
  <definition term="mysql.galera_status.local.send.queue_max">
    The maximum length of the send queue since the last FLUSH STATUS command.
    type: long
  </definition>
  <definition term="mysql.galera_status.local.send.queue_min">
    The minimum length of the send queue since the last FLUSH STATUS command.
    type: long
  </definition>
  <definition term="mysql.galera_status.local.state">
    Internal Galera Cluster FSM state number.
    type: keyword
  </definition>
  <definition term="mysql.galera_status.ready">
    Whether the server is ready to accept queries.
    type: keyword
  </definition>
</definitions>


## received

Write-Set receive status fields.
<definitions>
  <definition term="mysql.galera_status.received.count">
    Total number of write-sets received from other nodes.
    type: long
  </definition>
  <definition term="mysql.galera_status.received.bytes">
    Total size of write-sets received from other nodes.
    type: long
  </definition>
</definitions>


## repl

Replication status fields.
<definitions>
  <definition term="mysql.galera_status.repl.data_bytes">
    Total size of data replicated.
    type: long
  </definition>
  <definition term="mysql.galera_status.repl.keys">
    Total number of keys replicated.
    type: long
  </definition>
  <definition term="mysql.galera_status.repl.keys_bytes">
    Total size of keys replicated.
    type: long
  </definition>
  <definition term="mysql.galera_status.repl.other_bytes">
    Total size of other bits replicated.
    type: long
  </definition>
  <definition term="mysql.galera_status.repl.count">
    Total number of write-sets replicated (sent to other nodes).
    type: long
  </definition>
  <definition term="mysql.galera_status.repl.bytes">
    Total size of write-sets replicated.
    type: long
  </definition>
</definitions>


## performance

<applies-to>
  - Elastic Stack: Beta
</applies-to>

`performance` contains metrics related to the performance of a MySQL instance

## events_statements

Records statement events summarized by schema and digest
<definitions>
  <definition term="mysql.performance.events_statements.max.timer.wait">
    Maximum wait time of the summarized events that are timed
    type: long
  </definition>
  <definition term="mysql.performance.events_statements.last.seen">
    Time at which the digest was most recently seen
    type: date
  </definition>
  <definition term="mysql.performance.events_statements.quantile.95">
    The 95th percentile of the statement latency, in picoseconds
    type: long
  </definition>
  <definition term="mysql.performance.events_statements.digest">
    Performance schema digest
    type: text
  </definition>
  <definition term="mysql.performance.events_statements.count.star">
    Number of summarized events
    type: long
  </definition>
  <definition term="mysql.performance.events_statements.avg.timer.wait">
    Average wait time of the summarized events that are timed
    type: long
  </definition>
  <definition term="mysql.performance.events_statements.schemaname">
    Schema name.
    type: keyword
  </definition>
</definitions>


## table_io_waits

Records table I/O waits by index
<definitions>
  <definition term="mysql.performance.table_io_waits.object.schema">
    Schema name
    type: keyword
  </definition>
  <definition term="mysql.performance.table_io_waits.object.name">
    Table name
    type: keyword
  </definition>
  <definition term="mysql.performance.table_io_waits.index.name">
    Name of the index that was used when the table I/O wait event was recorded. PRIMARY indicates that table I/O used the primary index. NULL means that table I/O used no index. Inserts are counted against INDEX_NAME = NULL
    type: keyword
  </definition>
  <definition term="mysql.performance.table_io_waits.count.fetch">
    Number of all fetch operations > 0
    type: long
  </definition>
</definitions>


## query

<applies-to>
  - Elastic Stack: Beta
</applies-to>

`query` metricset fetches custom queries from the user to a MySQL instance.

## status

`status` contains the metrics that were obtained by the status SQL query.

## aborted

Aborted status fields.
<definitions>
  <definition term="mysql.status.aborted.clients">
    The number of connections that were aborted because the client died without closing the connection properly.
    type: long
  </definition>
  <definition term="mysql.status.aborted.connects">
    The number of failed attempts to connect to the MySQL server.
    type: long
  </definition>
</definitions>


## connection


## errors

<definitions>
  <definition term="mysql.status.connection.errors.peer_address">
    The number of errors that occurred while searching for connecting client IP addresses.
    type: long
  </definition>
  <definition term="mysql.status.connection.errors.accept">
    The number of errors that occurred during calls to accept() on the listening port.
    type: long
  </definition>
  <definition term="mysql.status.connection.errors.internal">
    The number of connections refused due to internal errors in the server, such as failure to start a new thread or an out-of-memory condition.
    type: long
  </definition>
  <definition term="mysql.status.connection.errors.max">
    The number of connections refused because the server max_connections limit was reached. thread or an out-of-memory condition.
    type: long
  </definition>
  <definition term="mysql.status.connection.errors.tcpwrap">
    The number of connections refused by the libwrap library.
    type: long
  </definition>
  <definition term="mysql.status.connection.errors.select">
    The number of errors that occurred during calls to select() or poll() on the listening port. (Failure of this operation does not necessarily means a client connection was rejected.)
    type: long
  </definition>
</definitions>


## cache


## ssl

SSL session cache hits and misses.
<definitions>
  <definition term="mysql.status.cache.ssl.hits">
    The number of SSL session cache hits.
    type: long
  </definition>
  <definition term="mysql.status.cache.ssl.misses">
    The number of SSL session cache misses.
    type: long
  </definition>
  <definition term="mysql.status.cache.ssl.size">
    The SSL session cache size.
    type: long
  </definition>
</definitions>


## table


## open_cache

<definitions>
  <definition term="mysql.status.cache.table.open_cache.hits">
    The number of hits for open tables cache lookups.
    type: long
  </definition>
  <definition term="mysql.status.cache.table.open_cache.misses">
    The number of misses for open tables cache lookups.
    type: long
  </definition>
  <definition term="mysql.status.cache.table.open_cache.overflows">
    Number of times, after a table is opened or closed, a cache instance has an unused entry and the size of the instance is larger than table_open_cache / table_open_cache_instances
    type: long
  </definition>
</definitions>


## binlog

<definitions>
  <definition term="mysql.status.binlog.cache.disk_use">
    type: long
  </definition>
  <definition term="mysql.status.binlog.cache.use">
    type: long
  </definition>
</definitions>


## bytes

Bytes stats.
<definitions>
  <definition term="mysql.status.bytes.received">
    The number of bytes received from all clients.
    type: long
    format: bytes
  </definition>
  <definition term="mysql.status.bytes.sent">
    The number of bytes sent to all clients.
    type: long
    format: bytes
  </definition>
</definitions>


## threads

Threads stats.
<definitions>
  <definition term="mysql.status.threads.cached">
    The number of cached threads.
    type: long
  </definition>
  <definition term="mysql.status.threads.created">
    The number of created threads.
    type: long
  </definition>
  <definition term="mysql.status.threads.connected">
    The number of connected threads.
    type: long
  </definition>
  <definition term="mysql.status.threads.running">
    The number of running threads.
    type: long
  </definition>
  <definition term="mysql.status.connections">
    type: long
  </definition>
</definitions>


## created

<definitions>
  <definition term="mysql.status.created.tmp.disk_tables">
    type: long
  </definition>
  <definition term="mysql.status.created.tmp.files">
    type: long
  </definition>
  <definition term="mysql.status.created.tmp.tables">
    type: long
  </definition>
</definitions>


## delayed

<definitions>
  <definition term="mysql.status.delayed.errors">
    type: long
  </definition>
  <definition term="mysql.status.delayed.insert_threads">
    type: long
  </definition>
  <definition term="mysql.status.delayed.writes">
    type: long
  </definition>
  <definition term="mysql.status.flush_commands">
    type: long
  </definition>
  <definition term="mysql.status.max_used_connections">
    type: long
  </definition>
</definitions>


## open

<definitions>
  <definition term="mysql.status.open.files">
    type: long
  </definition>
  <definition term="mysql.status.open.streams">
    type: long
  </definition>
  <definition term="mysql.status.open.tables">
    type: long
  </definition>
  <definition term="mysql.status.opened_tables">
    type: long
  </definition>
</definitions>


## command

<definitions>
  <definition term="mysql.status.command.delete">
    The number of DELETE queries since startup.
    type: long
  </definition>
  <definition term="mysql.status.command.insert">
    The number of INSERT queries since startup.
    type: long
  </definition>
  <definition term="mysql.status.command.select">
    The number of SELECT queries since startup.
    type: long
  </definition>
  <definition term="mysql.status.command.update">
    The number of UPDATE queries since startup.
    type: long
  </definition>
  <definition term="mysql.status.queries">
    The number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable. It does not count COM_PING or COM_STATISTICS commands.
    type: long
  </definition>
  <definition term="mysql.status.questions">
    The number of statements executed by the server. This includes only statements sent to the server by clients and not statements executed within stored programs, unlike the Queries variable. This variable does not count COM_PING, COM_STATISTICS, COM_STMT_PREPARE, COM_STMT_CLOSE, or COM_STMT_RESET commands.
    type: long
  </definition>
</definitions>


## handler

<definitions>
  <definition term="mysql.status.handler.commit">
    The number of internal COMMIT statements.
    type: long
  </definition>
  <definition term="mysql.status.handler.delete">
    The number of times that rows have been deleted from tables.
    type: long
  </definition>
  <definition term="mysql.status.handler.external_lock">
    The server increments this variable for each call to its external_lock() function, which generally occurs at the beginning and end of access to a table instance.
    type: long
  </definition>
  <definition term="mysql.status.handler.mrr_init">
    The number of times the server uses a storage engine's own Multi-Range Read implementation for table access.
    type: long
  </definition>
  <definition term="mysql.status.handler.prepare">
    A counter for the prepare phase of two-phase commit operations.
    type: long
  </definition>
</definitions>


## read

<definitions>
  <definition term="mysql.status.handler.read.first">
    The number of times the first entry in an index was read.
    type: long
  </definition>
  <definition term="mysql.status.handler.read.key">
    The number of requests to read a row based on a key.
    type: long
  </definition>
  <definition term="mysql.status.handler.read.last">
    The number of requests to read the last key in an index.
    type: long
  </definition>
  <definition term="mysql.status.handler.read.next">
    The number of requests to read the next row in key order.
    type: long
  </definition>
  <definition term="mysql.status.handler.read.prev">
    The number of requests to read the previous row in key order.
    type: long
  </definition>
  <definition term="mysql.status.handler.read.rnd">
    The number of requests to read a row based on a fixed position.
    type: long
  </definition>
  <definition term="mysql.status.handler.read.rnd_next">
    The number of requests to read the next row in the data file.
    type: long
  </definition>
  <definition term="mysql.status.handler.rollback">
    The number of requests for a storage engine to perform a rollback operation.
    type: long
  </definition>
  <definition term="mysql.status.handler.savepoint">
    The number of requests for a storage engine to place a savepoint.
    type: long
  </definition>
  <definition term="mysql.status.handler.savepoint_rollback">
    The number of requests for a storage engine to roll back to a savepoint.
    type: long
  </definition>
  <definition term="mysql.status.handler.update">
    The number of requests to update a row in a table.
    type: long
  </definition>
  <definition term="mysql.status.handler.write">
    The number of requests to insert a row in a table.
    type: long
  </definition>
</definitions>


## innodb


## rows

<definitions>
  <definition term="mysql.status.innodb.rows.reads">
    The number of rows reads into InnoDB tables.
    type: long
  </definition>
  <definition term="mysql.status.innodb.rows.inserted">
    The number of rows inserted into InnoDB tables.
    type: long
  </definition>
  <definition term="mysql.status.innodb.rows.deleted">
    The number of rows deleted into InnoDB tables.
    type: long
  </definition>
  <definition term="mysql.status.innodb.rows.updated">
    The number of rows updated into InnoDB tables.
    type: long
  </definition>
</definitions>


## buffer_pool

<definitions>
  <definition term="mysql.status.innodb.buffer_pool.dump_status">
    The progress of an operation to record the pages held in the InnoDB buffer pool, triggered by the setting of innodb_buffer_pool_dump_at_shutdown or innodb_buffer_pool_dump_now.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.load_status">
    The progress of an operation to warm up the InnoDB buffer pool by reading in a set of pages corresponding to an earlier point in time, triggered by the setting of innodb_buffer_pool_load_at_startup or innodb_buffer_pool_load_now.
    type: long
  </definition>
</definitions>


## bytes

<definitions>
  <definition term="mysql.status.innodb.buffer_pool.bytes.data">
    The total number of bytes in the InnoDB buffer pool containing data.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.bytes.dirty">
    The total current number of bytes held in dirty pages in the InnoDB buffer pool.
    type: long
  </definition>
</definitions>


## pages

<definitions>
  <definition term="mysql.status.innodb.buffer_pool.pages.data">
    The number of pages in the InnoDB buffer pool containing data.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.pages.dirty">
    The current number of dirty pages in the InnoDB buffer pool.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.pages.flushed">
    The number of requests to flush pages from the InnoDB buffer pool.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.pages.free">
    The number of free pages in the InnoDB buffer pool.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.pages.latched">
    The number of latched pages in the InnoDB buffer pool.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.pages.misc">
    The number of pages in the InnoDB buffer pool that are busy because they have been allocated for administrative overhead, such as row locks or the adaptive hash index.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.pages.total">
    The total size of the InnoDB buffer pool, in pages.
    type: long
  </definition>
</definitions>


## read

<definitions>
  <definition term="mysql.status.innodb.buffer_pool.read.ahead">
    The number of pages read into the InnoDB buffer pool by the read-ahead background thread.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.read.ahead_evicted">
    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.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.read.ahead_rnd">
    The number of "random" read-aheads initiated by InnoDB.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.read.requests">
    The number of logical read requests.
    type: long
  </definition>
</definitions>


## pool

<definitions>
  <definition term="mysql.status.innodb.buffer_pool.pool.reads">
    The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.pool.resize_status">
    The status of an operation to resize the InnoDB buffer pool dynamically, triggered by setting the innodb_buffer_pool_size parameter dynamically.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.pool.wait_free">
    Normally, writes to the InnoDB buffer pool happen in the background. 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.
    type: long
  </definition>
  <definition term="mysql.status.innodb.buffer_pool.write_requests">
    The number of writes done to the InnoDB buffer pool.
    type: long
  </definition>
</definitions>