Index of wsrep status variables

variable wsrep_local_state_uuid

This variable contains UUID state stored on the node.

variable wsrep_protocol_version

Version of the wsrep protocol used.

variable wsrep_last_committed

Sequence number of the last committed transaction.

variable wsrep_replicated

Total number of writesets sent to other nodes.

variable wsrep_replicated_bytes

Total size (in bytes) of writesets sent to other nodes.

variable wsrep_received

Total number of writesets received from other nodes.

variable wsrep_received_bytes

Total size (in bytes) of writesets received from other nodes.

variable wsrep_local_commits

Number of writesets commited on the node.

variable wsrep_local_cert_failures

Number of writesets that failed the certification test.

variable wsrep_local_bf_aborts

Number of local transactions that were aborted by slave transactions while being executed.

variable wsrep_local_replays

Number of transaction replays due to “asymmetric lock granularity”.

variable wsrep_local_send_queue

Current length of the send queue. Show the number of writesets waiting to be sent.

variable wsrep_local_send_queue_avg

Average length of the send queue since the last status query. When cluster experiences network throughput issues or replication throttling this value will be significantly bigger than 0.

variable wsrep_local_recv_queue

Current length of the receive queue. Show the number of writesets waiting to be applied.

variable wsrep_local_recv_queue_avg

Average length of the receive queue since the last status query. When this number is bigger than 0 this means node can’t apply writesets as fast as they’re received. This could be sign that node is overloaded and it will cause the replication throttling.

variable wsrep_flow_control_paused

Time since the last status query that replication was paused due to flow control.

variable wsrep_flow_control_sent

Number of FC_PAUSE events sent since the last status query.

variable wsrep_flow_control_recv

Number of FC_PAUSE events sent and received since the last status query.

variable wsrep_cert_deps_distance

Average distance between highest and lowest sequence numbet that can be possibly applied in parallel.

variable wsrep_apply_oooe

This variable shows parallelization efficiency, how often writests have been applied out-of-order.

variable wsrep_apply_oool

This variable shows how often was writeset with higher sequence number applied before the one with lower sequence number.

variable wsrep_apply_window

Average distance between highest and lowest concurrently applied sequence number.

variable wsrep_commit_oooe

This variable shows how often a transaction has been applied out of order.

variable wsrep_commit_oool

This variable currently isn’t being used.

variable wsrep_commit_window

Average distance between highest and lowest concurrently committed sequence number.

variable wsrep_local_state

This variable shows internal Galera state number. Possible values are:

• 1 - Joining (requesting/receiving State Transfer) - node is joining the cluster
• 2 - Donor/Desynced - node is the donor to the node joining the cluster
• 3 - Joined - node has joined the cluster
• 4 - Synced - node is synced with the cluster

variable wsrep_local_state_comment

Description of the wsrep_local_state variable.

variable wsrep_cert_index_size

variable wsrep_causal_reads_

Shows the number of writesets processed while the variable wsrep_causal_reads was set to ON.

variable wsrep_incoming_addresses

Shows the comma-separated list of incoming node addresses in the cluster.

variable wsrep_cluster_conf_id

Number of cluster membership changes happened.

variable wsrep_cluster_size

Current number of nodes in the cluster.

variable wsrep_cluster_state_uuid

This variable contains UUID state of the cluster. When this value is the same as the one in wsrep_local_state_uuid node is synced with the cluster.

variable wsrep_cluster_status

Status of the cluster component. Possible values are:

• Primary -
• Non-Primary -
• Disconnected -

variable wsrep_connected

variable wsrep_local_index

Node index in the cluster

variable wsrep_provider_name

Name of the wsrep provider (usually Galera).

variable wsrep_provider_vendor

Name of the wsrep provider vendor (usually Codership Oy)

variable wsrep_provider_version

Current version of the wsrep provider.

variable wsrep_ready

This variable shows if node is ready to accept queries. If status is OFF almost all the queries will fail with ERROR 1047 (08S01) Unknown Command error (unless wsrep_on variable is set to 0)