6.3. Galera Status Variables

These variables are Galera Cluster 0.8.x status variables. There are two types of wsrep-related status variables:

  • Galera Cluster-specific variables exported by Galera Cluster
  • Variables exported by MySQL. These variables are for the general wsrep provider.

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:

  • G—Galera Cluster
  • M—MySQL
Status Variable L Example Value Introduced Deprecated
wsrep_local_state_uuid G e2c9a15e-5485-11e0-0800- 6bbb637e7211    
wsrep_last_committed G 409745    
wsrep_replicated G 16109    
wsrep_replicated_bytes G 6526788    
wsrep_received G 17831    
wsrep_received_bytes G 6637093    
wsrep_local_commits G 14981    
wsrep_local_cert_failures G 333    
wsrep_local_bf_aborts G 960    
wsrep_local_replays G 0    
wsrep_local_send_queue G 1    
wsrep_local_send_queue_avg G 0.145000    
wsrep_local_recv_queue G 0    
wsrep_local_recv_queue_avg G 3.348452    
wsrep_flow_control_paused G 0.184353    
wsrep_flow_control_sent G 7    
wsrep_flow_control_recv G 11    
wsrep_cert_deps_distance G 23.88889    
wsrep_apply_oooe G 0.671120    
wsrep_apply_oool G 0.195248    
wsrep_apply_window G 5.163966    
wsrep_commit_oooe G 0.000000    
wsrep_commit_oool G 0.000000    
wsrep_commit_window G 0.000000    
wsrep_local_state G 4    
wsrep_local_state_comment G Synced    
wsrep_incoming_addresses G 10.0.0.1:3306,10.0.0.2: 3306,undefined    
wsrep_cluster_conf_id M 34    
wsrep_cluster_size M 3    
wsrep_cluster_state_uuid M e2c9a15e-5485-11e0- 0800-6bbb637e7211    
wsrep_cluster_status M Primary    
wsrep_local_index M 1    
wsrep_ready M ON    
wsrep_cert_index_size G 30936    
wsrep_protocol_version G 4    
wsrep_connected G ON    

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.