These variables are Galera Cluster 0.8.x status variables. There are two types of wsrep-related status variables:
This distinction is of importance for developers only. For convenience, all status variables are presented as a single list below.
The location (L) of the variable is presented in the second column from the left. The values are:
wsrep_local_state_uuid
The UUID of the state stored on this node. See wsrep API.
wsrep_last_committed
Sequence number of the last committed transaction. See wsrep API.
wsrep_replicated
Total number of writesets replicated (sent to other nodes).
wsrep_replicated_bytes
Total size of writesets replicated.
wsrep_received
Total number of writesets received from other nodes.
wsrep_received_bytes
Total size of writesets received from other nodes.
wsrep_local_commits
Total number of local transactions committed.
wsrep_local_cert_failures
Total number of local transactions that failed certification test.
wsrep_local_bf_aborts
Total number of local transactions that were aborted by slave transactions while in execution.
wsrep_local_replays
Total number of transaction replays due to asymmetric lock granularity.
wsrep_local_send_queue
Current (instantaneous) length of the send queue.
wsrep_local_send_queue_avg
Send queue length averaged over interval since the last status query. Values considerably larger than 0.0 indicate replication throttling or network throughput issue.
wsrep_local_recv_queue
Current (instantaneous) length of the recv queue.
wsrep_local_recv_queue_avg
Recv queue length averaged over interval since the last status query. Values considerably larger than 0.0 mean that the node cannot apply writesets as fast as they are received and will generate a lot of replication throttling.
wsrep_flow_control_paused
The fraction of time since the last status query that replication was paused due to flow control.
In other words, how much the slave lag is slowing down the cluster.
wsrep_flow_control_sent
Number of FC_PAUSE events sent since the last status query.
wsrep_flow_control_recv
Number of FC_PAUSE events received since the last status query (counts the events sent).
wsrep_cert_deps_distance
Average distance between highest and lowest seqno that can be possibly applied in parallel (potential degree of parallelization).
wsrep_apply_oooe
How often applier started writeset applying out-of-order (parallelization efficiency).
wsrep_apply_oool
How often writeset was so slow to apply that writeset with higher seqno’s were applied earlier. Values closer to 0 refer to a greater gap between slow and fast writesets.
wsrep_apply_window
Average distance between highest and lowest concurrently applied seqno.
wsrep_commit_oooe
How often a transaction was committed out of order.
wsrep_commit_oool
No meaning.
wsrep_commit_window
Average distance between highest and lowest concurrently committed seqno.
wsrep_local_state
Internal Galera Cluster FSM state number. See Node State Changes.
wsrep_local_state_comment
Human-readable explanation of the state.
wsrep_incoming_addresses
Comma-separated list of incoming server addresses in the cluster component.
wsrep_cluster_conf_id
Total number of cluster membership changes happened.
wsrep_cluster_size
Current number of members in the cluster.
wsrep_cluster_state_uuid
See wsrep API.
wsrep_cluster_status
Status of this cluster component: PRIMARY or NON_PRIMARY.
wsrep_local_index
This node index in the cluster (base 0).
wsrep_ready
Whether the server is ready to accept queries. If this status is OFF, almost all of the queries fill fail with:
ERROR 1047 (08S01) Unknown Command
unless the wsrep_on session variable is set to 0.
wsrep_cert_index_size
The number of entries in the certification index.
wsrep_protocol_version
The version of the wsrep protocol used.
wsrep_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.