Index of wsrep status variables¶

`wsrep_apply_oooe`¶

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

`wsrep_apply_oool`¶

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

`wsrep_apply_window`¶

Average distance between highest and lowest concurrently applied sequence numbers.

`wsrep_causal_reads`¶

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

`wsrep_cert_bucket_count`¶

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

`wsrep_cert_deps_distance`¶

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

`wsrep_cert_index_size`¶

Number of entries in the certification index.

`wsrep_cert_interval`¶

Average number of write-sets received while a transaction replicates.

`wsrep_cluster_conf_id`¶

Number of cluster membership changes that have taken place.

`wsrep_cluster_size`¶

Current number of nodes in the cluster.

`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.

`wsrep_cluster_status`¶

Status of the cluster component. Possible values are:

Primary
Non-Primary
Disconnected

`wsrep_commit_oooe`¶

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

`wsrep_commit_oool`¶

This variable currently has no meaning.

`wsrep_commit_window`¶

Average distance between highest and lowest concurrently committed sequence number.

`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.

`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.

`wsrep_evs_evict_list`¶

List of UUIDs of the evicted nodes.

`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>.

`wsrep_evs_state`¶

Internal EVS protocol state.

`wsrep_flow_control_interval`¶

This variable shows the lower and upper limits for Galera flow control. The upper limit is the maximum allowed number of requests in the queue. If the queue reaches the upper limit, new requests are denied. As existing requests get processed, the queue decreases, and once it reaches the lower limit, new requests will be allowed again.

`wsrep_flow_control_interval_high`¶

Shows the upper limit for flow control to trigger.

`wsrep_flow_control_interval_low`¶

Shows the lower limit for flow control to stop.

`wsrep_flow_control_paused`¶

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

`wsrep_flow_control_paused_ns`¶

Total time spent in a paused state measured in nanoseconds.

`wsrep_flow_control_recv`¶

The number of FC_PAUSE events received since the last status query. Unlike most status variables, this counter does not reset each time you run the query. This counter is reset when the server restarts.

`wsrep_flow_control_requested`¶

This variable returns whether or not a node requested a replication pause.

`wsrep_flow_control_sent`¶

The number of FC_PAUSE events sent since the last status query. Unlike most status variables, this counter does not reset each time you run the query. This counter is reset when the server restarts.

`wsrep_flow_control_status`¶

This variable shows whether a node has flow control enabled for normal traffic. It does not indicate the status of flow control during SST.

`wsrep_gcache_pool_size`¶

This variable shows the size of the page pool and dynamic memory allocated for GCache (in bytes).

`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.

`wsrep_incoming_addresses`¶

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

`wsrep_ist_receive_status`¶

This variable displays the progress of IST for joiner node. If IST is not running, the value is blank. If IST is running, the value is the percentage of transfer completed.

`wsrep_ist_receive_seqno_end`¶

The sequence number of the last transaction in IST.

`wsrep_ist_receive_seqno_current`¶

The sequence number of the current transaction in IST.

`wsrep_ist_receive_seqno_start`¶

The sequence number of the first transaction in IST.

`wsrep_last_applied`¶

Sequence number of the last applied transaction.

`wsrep_last_committed`¶

Sequence number of the last committed transaction.

`wsrep_local_bf_aborts`¶

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

`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).

`wsrep_local_cert_failures`¶

Number of writesets that failed the certification test.

`wsrep_local_commits`¶

Number of writesets commited on the node.

`wsrep_local_index`¶

Node’s index in the cluster.

`wsrep_local_recv_queue`¶

Current length of the receive queue (that is, the number of writesets waiting to be applied).

`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.

`wsrep_local_replays`¶

Number of transaction replays due to asymmetric lock granularity.

`wsrep_local_send_queue`¶

Current length of the send queue (that is, the number of writesets waiting to be sent).

`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.

`wsrep_local_state`¶

Internal Galera cluster FSM state number.

`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

`wsrep_local_state_uuid`¶

The UUID of the state stored on the node.

`wsrep_monitor_status`¶

The status of the local monitor (local and replicating actions), apply monitor (apply actions of write-set), and commit monitor (commit actions of write sets). In the value of this variable, each monitor (L: Local, A: Apply, C: Commit) is represented as a last_entered, and last_left pair:

wsrep_monitor_status (L/A/C)    [ ( 7, 5), (2, 2), ( 2, 2) ]

last_entered

Shows which transaction or write-set has recently entered the queue.

last_left

Shows which last transaction or write-set has been executed and left the queue.

According to the Galera protocol, transactions can be applied in parallel but must be committed in a given order. This rule implies that there can be multiple transactions in the apply state at a given point of time but transactions are committed sequentially.

`wsrep_protocol_version`¶

Version of the wsrep protocol used.

`wsrep_provider_name`¶

Name of the wsrep provider (usually Galera).

`wsrep_provider_vendor`¶

Name of the wsrep provider vendor (usually Codership Oy)

`wsrep_provider_version`¶

Current version of the wsrep provider.

`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).

See also

Galera status variable: wsrep_ready

`wsrep_received`¶

Total number of writesets received from other nodes.

`wsrep_received_bytes`¶

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

`wsrep_repl_data_bytes`¶

Total size (in bytes) of data replicated.

`wsrep_repl_keys`¶

Total number of keys replicated.

`wsrep_repl_keys_bytes`¶

Total size (in bytes) of keys replicated.

`wsrep_repl_other_bytes`¶

Total size of other bits replicated.

`wsrep_replicated`¶

Total number of writesets sent to other nodes.

`wsrep_replicated_bytes`¶

Total size of replicated writesets. To compute the actual size of bytes sent over network to cluster peers, multiply the value of this variable by the number of cluster peers in the given network segment.

Get expert help¶

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.

Community Forum Get a Percona Expert

Last update: 2023-09-11

Index of wsrep status variables¶

wsrep_apply_oooe¶

wsrep_apply_oool¶

wsrep_apply_window¶

wsrep_causal_reads¶

wsrep_cert_bucket_count¶

wsrep_cert_deps_distance¶

wsrep_cert_index_size¶

wsrep_cert_interval¶

wsrep_cluster_conf_id¶

wsrep_cluster_size¶

wsrep_cluster_state_uuid¶

wsrep_cluster_status¶

wsrep_commit_oooe¶

wsrep_commit_oool¶

wsrep_commit_window¶

wsrep_connected¶

wsrep_evs_delayed¶

wsrep_evs_evict_list¶

wsrep_evs_repl_latency¶

wsrep_evs_state¶

wsrep_flow_control_interval¶

wsrep_flow_control_interval_high¶

wsrep_flow_control_interval_low¶

wsrep_flow_control_paused¶

wsrep_flow_control_paused_ns¶

wsrep_flow_control_recv¶

wsrep_flow_control_requested¶

wsrep_flow_control_sent¶

wsrep_flow_control_status¶

wsrep_gcache_pool_size¶

wsrep_gcomm_uuid¶

wsrep_incoming_addresses¶

wsrep_ist_receive_status¶

wsrep_ist_receive_seqno_end¶

wsrep_ist_receive_seqno_current¶

wsrep_ist_receive_seqno_start¶

wsrep_last_applied¶

wsrep_last_committed¶

wsrep_local_bf_aborts¶

wsrep_local_cached_downto¶

wsrep_local_cert_failures¶

wsrep_local_commits¶

wsrep_local_index¶

wsrep_local_recv_queue¶

wsrep_local_recv_queue_avg¶

wsrep_local_replays¶

wsrep_local_send_queue¶

wsrep_local_send_queue_avg¶

wsrep_local_state¶

wsrep_local_state_comment¶

wsrep_local_state_uuid¶

wsrep_monitor_status¶

wsrep_protocol_version¶

wsrep_provider_name¶

wsrep_provider_vendor¶

wsrep_provider_version¶

wsrep_ready¶

wsrep_received¶

wsrep_received_bytes¶

wsrep_repl_data_bytes¶

wsrep_repl_keys¶

wsrep_repl_keys_bytes¶

wsrep_repl_other_bytes¶

wsrep_replicated¶

wsrep_replicated_bytes¶