MySQL fields

edit

MySQL server status metrics collected from MySQL.

mysql fields

edit

mysql contains the metrics that were obtained from MySQL query.

galera_status fields

edit

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

apply fields

edit

Apply 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

edit

Certification 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

edit

Cluster 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

edit

Commit 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

edit

Evs 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

edit

Flow 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

edit

Node 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

edit

Node 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

edit

Node 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

edit

Write-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

edit

Replication 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

edit

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

aborted fields

edit

Aborted 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

edit

Bytes 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

edit

Threads 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.