MySQL fieldsedit

MySQL server status metrics collected from MySQL.

mysqledit

mysql contains the metrics that were obtained from MySQL query.

galera_statusedit

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

applyedit

Apply status fields.

mysql.galera_status.apply.oooe

How often applier started write-set applying out-of-order (parallelization efficiency).

type: double

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

mysql.galera_status.apply.window

Average distance between highest and lowest concurrently applied seqno.

type: double

certedit

Certification status fields.

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

mysql.galera_status.cert.index_size

The number of entries in the certification index.

type: long

mysql.galera_status.cert.interval

Average number of transactions received while a transaction replicates.

type: double

clusteredit

Cluster status fields.

mysql.galera_status.cluster.conf_id

Total number of cluster membership changes happened.

type: long

mysql.galera_status.cluster.size

Current number of members in the cluster.

type: long

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

commitedit

Commit status fields.

mysql.galera_status.commit.oooe

How often a transaction was committed out of order.

type: double

mysql.galera_status.commit.window

Average distance between highest and lowest concurrently committed seqno.

type: long

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

evsedit

Evs Fields.

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

mysql.galera_status.evs.state

Shows the internal state of the EVS Protocol.

type: keyword

flow_ctledit

Flow Control fields.

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

mysql.galera_status.flow_ctl.paused_ns

The total time spent in a paused state measured in nanoseconds.

type: long

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

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

mysql.galera_status.last_committed

The sequence number, or seqno, of the last committed transaction.

type: long

localedit

Node specific Cluster status fields.

mysql.galera_status.local.bf_aborts

Total number of local transactions that were aborted by slave transactions while in execution.

type: long

mysql.galera_status.local.cert_failures

Total number of local transactions that failed certification test.

type: long

mysql.galera_status.local.commits

Total number of local transactions committed.

type: long

recvedit

Node specific recv fields.

mysql.galera_status.local.recv.queue

Current (instantaneous) length of the recv queue.

type: long

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

mysql.galera_status.local.recv.queue_max

The maximum length of the recv queue since the last FLUSH STATUS command.

type: long

mysql.galera_status.local.recv.queue_min

The minimum length of the recv queue since the last FLUSH STATUS command.

type: long

mysql.galera_status.local.replays

Total number of transaction replays due to asymmetric lock granularity.

type: long

sendedit

Node specific sent fields.

mysql.galera_status.local.send.queue

Current (instantaneous) length of the send queue.

type: long

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

mysql.galera_status.local.send.queue_max

The maximum length of the send queue since the last FLUSH STATUS command.

type: long

mysql.galera_status.local.send.queue_min

The minimum length of the send queue since the last FLUSH STATUS command.

type: long

mysql.galera_status.local.state

Internal Galera Cluster FSM state number.

type: keyword

mysql.galera_status.ready

Whether the server is ready to accept queries.

type: keyword

receivededit

Write-Set receive status fields.

mysql.galera_status.received.count

Total number of write-sets received from other nodes.

type: long

mysql.galera_status.received.bytes

Total size of write-sets received from other nodes.

type: long

repledit

Replication status fields.

mysql.galera_status.repl.data_bytes

Total size of data replicated.

type: long

mysql.galera_status.repl.keys

Total number of keys replicated.

type: long

mysql.galera_status.repl.keys_bytes

Total size of keys replicated.

type: long

mysql.galera_status.repl.other_bytes

Total size of other bits replicated.

type: long

mysql.galera_status.repl.count

Total number of write-sets replicated (sent to other nodes).

type: long

mysql.galera_status.repl.bytes

Total size of write-sets replicated.

type: long

statusedit

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

abortededit

Aborted status fields.

mysql.status.aborted.clients

The number of connections that were aborted because the client died without closing the connection properly.

type: long

mysql.status.aborted.connects

The number of failed attempts to connect to the MySQL server.

type: long

binlogedit

mysql.status.binlog.cache.disk_use
type: long
mysql.status.binlog.cache.use
type: long

bytesedit

Bytes stats.

mysql.status.bytes.received

The number of bytes received from all clients.

type: long

format: bytes

mysql.status.bytes.sent

The number of bytes sent to all clients.

type: long

format: bytes

threadsedit

Threads stats.

mysql.status.threads.cached

The number of cached threads.

type: long

mysql.status.threads.created

The number of created threads.

type: long

mysql.status.threads.connected

The number of connected threads.

type: long

mysql.status.threads.running

The number of running threads.

type: long

mysql.status.connections
type: long

creatededit

mysql.status.created.tmp.disk_tables
type: long
mysql.status.created.tmp.files
type: long
mysql.status.created.tmp.tables
type: long

delayededit

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

openedit

mysql.status.open.files
type: long
mysql.status.open.streams
type: long
mysql.status.open.tables
type: long
mysql.status.opened_tables
type: long

commandedit

mysql.status.command.delete

The number of DELETE queries since startup.

type: long

mysql.status.command.insert

The number of INSERT queries since startup.

type: long

mysql.status.command.select

The number of SELECT queries since startup.

type: long

mysql.status.command.update

The number of UPDATE queries since startup.

type: long