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