MySQL fieldsedit
MySQL server status metrics collected from MySQL.
mysql fieldsedit
mysql
contains the metrics that were obtained from MySQL query.
galera_status fieldsedit
galera_status
contains the metrics that were obtained by the status SQL query on Galera.
apply fieldsedit
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 fieldsedit
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 fieldsedit
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 fieldsedit
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 fieldsedit
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 fieldsedit
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 fieldsedit
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 fieldsedit
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 fieldsedit
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 fieldsedit
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 fieldsedit
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 fieldsedit
status
contains the metrics that were obtained by the status SQL query.
aborted fieldsedit
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 fieldsedit
-
mysql.status.binlog.cache.disk_use
-
type: long
-
mysql.status.binlog.cache.use
-
type: long
bytes fieldsedit
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 fieldsedit
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 fieldsedit
-
mysql.status.created.tmp.disk_tables
-
type: long
-
mysql.status.created.tmp.files
-
type: long
-
mysql.status.created.tmp.tables
-
type: long
delayed fieldsedit
-
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 fieldsedit
-
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 fieldsedit
-
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.