Index of wsrep status variables¶

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 a writeset with a higher sequence number was applied before one with a lower sequence number.

variable wsrep_apply_window¶

Average distance between highest and lowest concurrently applied sequence numbers.

variable wsrep_causal_reads_¶

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

variable wsrep_cert_bucket_count¶

This variable, implemented in 5.6.24-25.11, shows the number of cells in the certification index hash-table.

variable wsrep_cert_deps_distance¶

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

variable wsrep_cert_index_size¶

Number of entries in the certification index.

variable wsrep_cluster_conf_id¶

Number of cluster membership changes that have taken place.

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 - Node has a quorum,
• Non-Primary - Node has lost a quorum (for example 2 out 4 nodes get partitioned and see each other but don’t have a quorum),
• Disconnected - Node is unable to connect to other nodes/cluster.

variable wsrep_commit_oooe¶

This variable shows how often a transaction was committed out of order.

variable wsrep_commit_oool¶

This variable currently has no meaning.

variable wsrep_commit_window¶

Average distance between highest and lowest concurrently committed sequence number.

variable wsrep_connected¶

This variable shows if the node is connected to the cluster. If the value is OFF, the node has not yet connected to any of the cluster components. This may be due to misconfiguration.

variable wsrep_desync_count¶

Number of desync operations currently in progress on the node. This status variable increments every time a node is desynced from the cluster (for example, when wsrep_desync is enabled). The node can only sync to the cluster when the value is 0, meaning that there are no operations running on the node that require the node to desync.

variable wsrep_evs_delayed¶

Comma separated list of nodes that are considered delayed. The node format is <uuid>:<address>:<count>, where <count> is the number of entries on delayed list for that node.

variable wsrep_evs_evict_list¶

List of UUIDs of the evicted nodes.

variable wsrep_evs_repl_latency¶

This status variable provides information regarding group communication replication latency. This latency is measured in seconds from when a message is sent out to when a message is received.

The format of the output is <min>/<avg>/<max>/<std_dev>/<sample_size>.

variable wsrep_evs_state¶

Internal EVS protocol state.

variable wsrep_flow_control_paused¶

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

variable wsrep_flow_control_paused_ns¶

Total time spent in a paused state measured in nanoseconds.

variable wsrep_flow_control_recv¶

Number of FC_PAUSE events received since the last status query.

variable wsrep_flow_control_sent¶

Number of FC_PAUSE events sent since the last status query.

variable wsrep_gcache_pool_size¶

This variable, implemented in 5.6.24-25.11, shows the size of the page pool and dynamic memory allocated for GCache (in bytes).

variable wsrep_gcomm_uuid¶

This status variable exposes UUIDs in gvwstate.dat, which are Galera view IDs (thus unrelated to cluster state UUIDs). This UUID is unique for each node. You will need to know this value when using manual eviction feature.

variable wsrep_incoming_addresses¶

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

variable wsrep_last_committed¶

Sequence number of the last committed transaction.

variable wsrep_local_bf_aborts¶

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

variable wsrep_local_cached_downto¶

The lowest sequence number in GCache. This information can be helpful with determining IST and SST. If the value is 0, then it means there are no writesets in GCache (usual for a single node).

variable wsrep_local_cert_failures¶

Number of writesets that failed the certification test.

variable wsrep_local_commits¶

Number of writesets commited on the node.

variable wsrep_local_index¶

Node’s index in the cluster.

variable wsrep_local_recv_queue¶

Current length of the receive queue (that is, 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 are received. This could be a sign that the node is overloaded and it may cause replication throttling.

variable wsrep_local_replays¶

Number of transaction replays due to asymmetric lock granularity.

variable wsrep_local_send_queue¶

Current length of the send queue (that is, 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_state¶

variable wsrep_local_state_comment¶

Internal number and the corresponding human-readable comment of the node’s state. Possible values are:

Num	Comment	Description
1	Joining	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_uuid¶

The UUID of the state stored on the node.

variable wsrep_protocol_version¶

Version of the wsrep protocol used.

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 queries will fail with ERROR 1047 (08S01) Unknown Command error (unless the wsrep_on variable is set to 0)

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_repl_data_bytes¶

Total size (in bytes) of data replicated.

variable wsrep_repl_keys¶

Total number of keys replicated.

variable wsrep_repl_keys_bytes¶

Total size (in bytes) of keys replicated.

variable wsrep_repl_other_bytes¶

Total size of other bits replicated.

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.