MySQL fields
editMySQL fields
editMySQL server status metrics collected from MySQL.
mysql fields
editmysql
contains the metrics that were obtained from MySQL query.
galera_status fields
editgalera_status
contains the metrics that were obtained by the status SQL query on Galera.
apply fields
editApply status fields.
-
mysql.galera_status.apply.oooe
-
type: double
How often applier started write-set applying out-of-order (parallelization efficiency).
-
mysql.galera_status.apply.oool
-
type: double
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.
-
mysql.galera_status.apply.window
-
type: double
Average distance between highest and lowest concurrently applied seqno.
cert fields
editCertification status fields.
-
mysql.galera_status.cert.deps_distance
-
type: double
Average distance between highest and lowest seqno value that can be possibly applied in parallel (potential degree of parallelization).
-
mysql.galera_status.cert.index_size
-
type: long
The number of entries in the certification index.
-
mysql.galera_status.cert.interval
-
type: double
Average number of transactions received while a transaction replicates.
cluster fields
editCluster status fields.
-
mysql.galera_status.cluster.conf_id
-
type: long
Total number of cluster membership changes happened.
-
mysql.galera_status.cluster.size
-
type: long
Current number of members in the cluster.
-
mysql.galera_status.cluster.status
-
type: keyword
Status of this cluster component. That is, whether the node is part of a PRIMARY or NON_PRIMARY component.
commit fields
editCommit status fields.
-
mysql.galera_status.commit.oooe
-
type: double
How often a transaction was committed out of order.
-
mysql.galera_status.commit.window
-
type: long
Average distance between highest and lowest concurrently committed seqno.
-
mysql.galera_status.connected
-
type: keyword
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.
evs fields
editEvs Fields.
-
mysql.galera_status.evs.evict
-
type: keyword
Lists the UUID’s of all nodes evicted from the cluster. Evicted nodes cannot rejoin the cluster until you restart their mysqld processes.
-
mysql.galera_status.evs.state
-
type: keyword
Shows the internal state of the EVS Protocol.
flow_ctl fields
editFlow Control fields.
-
mysql.galera_status.flow_ctl.paused
-
type: double
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.
-
mysql.galera_status.flow_ctl.paused_ns
-
type: long
The total time spent in a paused state measured in nanoseconds.
-
mysql.galera_status.flow_ctl.recv
-
type: long
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.
-
mysql.galera_status.flow_ctl.sent
-
type: long
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.
-
mysql.galera_status.last_committed
-
type: long
The sequence number, or seqno, of the last committed transaction.
local fields
editNode specific Cluster status fields.
-
mysql.galera_status.local.bf_aborts
-
type: long
Total number of local transactions that were aborted by slave transactions while in execution.
-
mysql.galera_status.local.cert_failures
-
type: long
Total number of local transactions that failed certification test.
-
mysql.galera_status.local.commits
-
type: long
Total number of local transactions committed.
recv fields
editNode specific recv fields.
-
mysql.galera_status.local.recv.queue
-
type: long
Current (instantaneous) length of the recv queue.
-
mysql.galera_status.local.recv.queue_avg
-
type: double
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.
-
mysql.galera_status.local.recv.queue_max
-
type: long
The maximum length of the recv queue since the last FLUSH STATUS command.
-
mysql.galera_status.local.recv.queue_min
-
type: long
The minimum length of the recv queue since the last FLUSH STATUS command.
-
mysql.galera_status.local.replays
-
type: long
Total number of transaction replays due to asymmetric lock granularity.
send fields
editNode specific sent fields.
-
mysql.galera_status.local.send.queue
-
type: long
Current (instantaneous) length of the send queue.
-
mysql.galera_status.local.send.queue_avg
-
type: double
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.
-
mysql.galera_status.local.send.queue_max
-
type: long
The maximum length of the send queue since the last FLUSH STATUS command.
-
mysql.galera_status.local.send.queue_min
-
type: long
The minimum length of the send queue since the last FLUSH STATUS command.
-
mysql.galera_status.local.state
-
type: keyword
Internal Galera Cluster FSM state number.
-
mysql.galera_status.ready
-
type: keyword
Whether the server is ready to accept queries.
received fields
editWrite-Set receive status fields.
-
mysql.galera_status.received.count
-
type: long
Total number of write-sets received from other nodes.
-
mysql.galera_status.received.bytes
-
type: long
Total size of write-sets received from other nodes.
repl fields
editReplication status fields.
-
mysql.galera_status.repl.data_bytes
-
type: long
Total size of data replicated.
-
mysql.galera_status.repl.keys
-
type: long
Total number of keys replicated.
-
mysql.galera_status.repl.keys_bytes
-
type: long
Total size of keys replicated.
-
mysql.galera_status.repl.other_bytes
-
type: long
Total size of other bits replicated.
-
mysql.galera_status.repl.count
-
type: long
Total number of write-sets replicated (sent to other nodes).
-
mysql.galera_status.repl.bytes
-
type: long
Total size of write-sets replicated.
status fields
editstatus
contains the metrics that were obtained by the status SQL query.
aborted fields
editAborted status fields.
-
mysql.status.aborted.clients
-
type: long
The number of connections that were aborted because the client died without closing the connection properly.
-
mysql.status.aborted.connects
-
type: long
The number of failed attempts to connect to the MySQL server.
binlog fields
edit-
mysql.status.binlog.cache.disk_use
-
type: long
-
mysql.status.binlog.cache.use
-
type: long
bytes fields
editBytes stats.
-
mysql.status.bytes.received
-
type: long
format: bytes
The number of bytes received from all clients.
-
mysql.status.bytes.sent
-
type: long
format: bytes
The number of bytes sent to all clients.
threads fields
editThreads stats.
-
mysql.status.threads.cached
-
type: long
The number of cached threads.
-
mysql.status.threads.created
-
type: long
The number of created threads.
-
mysql.status.threads.connected
-
type: long
The number of connected threads.
-
mysql.status.threads.running
-
type: long
The number of running threads.
-
mysql.status.connections
-
type: long
created fields
edit-
mysql.status.created.tmp.disk_tables
-
type: long
-
mysql.status.created.tmp.files
-
type: long
-
mysql.status.created.tmp.tables
-
type: long
delayed fields
edit-
mysql.status.delayed.errors
-
type: long
-
mysql.status.delayed.insert_threads
-
type: long
-
mysql.status.delayed.writes
-
type: long
-
mysql.status.flush_commands
-
type: long
-
mysql.status.max_used_connections
-
type: long
open fields
edit-
mysql.status.open.files
-
type: long
-
mysql.status.open.streams
-
type: long
-
mysql.status.open.tables
-
type: long
-
mysql.status.opened_tables
-
type: long
command fields
edit-
mysql.status.command.delete
-
type: long
The number of DELETE queries since startup.
-
mysql.status.command.insert
-
type: long
The number of INSERT queries since startup.
-
mysql.status.command.select
-
type: long
The number of SELECT queries since startup.
-
mysql.status.command.update
-
type: long
The number of UPDATE queries since startup.