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. They’re noted as to whether they are exported by Galera or by MySQL.

../_images/training.jpg

Status Variable

Exporter
Example
Value
Initial
Version
wsrep_apply_oooe Galera 0.671120 1.0
wsrep_apply_oool Galera 0.195248 1.0
wsrep_apply_waits Galera 13549 3.34,4.9
wsrep_apply_window Galera 5.163966 1.0
wsrep_cert_deps_distance Galera 23.88889 1.0
wsrep_cert_index_size Galera 30936 1.0
wsrep_cert_interval Galera   1.0
wsrep_cluster_conf_id MySQL 34 1.0
wsrep_cluster_size MySQL   1.0
wsrep_cluster_state_uuid MySQL   1.0
wsrep_cluster_status MySQL Primary 1.0
wsrep_cluster_weight MySQL 3 3.24
wsrep_commit_oooe Galera 0.000000 1.0
wsrep_commit_oool Galera 0.000000 1.0
wsrep_commit_window Galera 0.000000 1.0
wsrep_connected Galera ON 1.0
wsrep_desync_count Galera 0 3.0
wsrep_evs_delayed Galera   3.8
wsrep_evs_evict_list Galera   3.0
wsrep_evs_repl_latency Galera   3.0
wsrep_evs_state Galera   3.8
wsrep_flow_control_active Galera false 3.31
wsrep_flow_control_paused Galera 0.184353 1.0
wsrep_flow_control_paused_ns Galera 20222491180 1.0
wsrep_flow_control_recv Galera 11 1.0
wsrep_flow_control_requested Galera false 3.31
wsrep_flow_control_sent Galera 7 1.0
wsrep_gcomm_uuid Galera   1.0
wsrep_gmcast_seqment Galera 2 3.31
wsrep_incoming_addresses Galera   1.0
wsrep_ist_receive_status Galera   1.0
wsrep_last_committed Galera 409745 1.0
wsrep_local_bf_aborts Galera 960 1.0
wsrep_local_cached_downto Galera   1.0
wsrep_local_cert_failures Galera 333 1.0
wsrep_local_commits Galera 14981 1.0
wsrep_local_index Galera 1 1.0
wsrep_local_recv_queue Galera 0 1.0
wsrep_local_recv_queue_avg Galera 3.348452 1.0
wsrep_local_recv_queue_max Galera 10 1.0
wsrep_local_recv_queue_min Galera 0 1.0
wsrep_local_replays Galera 0 1.0
wsrep_local_send_queue Galera 1 1.0
wsrep_local_send_queue_avg Galera 0.145000 1.0
wsrep_local_send_queue_max Galera 10 1.0
wsrep_local_send_queue_min Galera 0 1.0
wsrep_local_state Galera 4 1.0
wsrep_local_state_comment Galera Synced 1.0
wsrep_local_state_uuid Galera   1.0
wsrep_open_connections Galera 3 3.24
wsrep_open_transactions Galera 25 3.24
wsrep_protocol_version Galera 4 1.0
wsrep_provider_name MySQL Galera 1.0
wsrep_provider_vendor MySQL   1.0
wsrep_provider_version MySQL   1.0
wsrep_ready MySQL ON 1.0
wsrep_received Galera 17831 1.0
wsrep_received_bytes Galera 6637093 1.0
wsrep_repl_data_bytes Galera 265035226 1.0
wsrep_repl_keys Galera 797399 1.0
wsrep_repl_keys_bytes Galera 11203721 1.0
wsrep_repl_other_bytes Galera 0 1.0
wsrep_replicated Galera 16109 1.0
wsrep_replicated_bytes Galera 6526788 1.0

wsrep_apply_oooe

How often applier started write-set applying out-of-order (parallelization efficiency).

Example Value 0.671120
Location Galera
Initial Version 1.0

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_apply_oooe';

+------------------+----------+
| Variable_name    | Value    |
+------------------+----------+
| wsrep_apply_oooe | 0.671120 |
+------------------+----------+

wsrep_apply_oool

How often write-set was so slow to apply that write-set with higher seqno’s were applied earlier. Values closer to 0 refer to a greater gap between slow and fast write-sets.

Example Value 0.195248
Location Galera
Initial Version 1.0

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_apply_oool';

+------------------+----------+
| Variable_name    | Value    |
+------------------+----------+
| wsrep_apply_oool | 0.195248 |
+------------------+----------+

wsrep_apply_waits

Number of times an applier thread has waited for the applying order.

Example Value 13549
Location Galera
Initial Version 3.34,4.9

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_apply_waits';

+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| wsrep_apply_waits | 13549 |
+-------------------+-------+

wsrep_apply_window

Average distance between highest and lowest concurrently applied seqno.

Example Value 5.163966
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_apply_window';

+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| wsrep_apply_window | 5.163966 |
+--------------------+----------+

wsrep_cert_deps_distance

Average distance between highest and lowest seqno value that can be possibly applied in parallel (potential degree of parallelization).

Example Value 23.888889
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_cert_deps_distance';

+--------------------------+----------+
| Variable_name            | Value    |
+--------------------------+----------+
| wsrep_cert_deps_distance | 23.88889 |
+--------------------------+----------+

wsrep_cert_index_size

The number of entries in the certification index.

Example Value 30936
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_certs_index_size';

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| wsrep_certs_index_size | 30936 |
+------------------------+-------+

wsrep_cert_interval

Average number of transactions received while a transaction replicates.

Example Value 1.0
Location Galera
Initial Version ???

When a node replicates a write-set to the cluster, it can take some time before all the nodes in the cluster receive it. By the time a given node receives, orders and commits a write-set, it may receive and potentially commit others, changing the state of the database from when the write-set was sent and rendering the transaction inapplicable.

To prevent this, Galera Cluster checks write-sets against all write-sets within its certification interval for potential conflicts. Using the wsrep_cert_interval status variable, you can see the average number of transactions with the certification interval.

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_cert_interval';

+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| wsrep_cert_interval | 1.0   |
+---------------------+-------+

This shows you the number of write-sets concurrently replicating to the cluster. In a fully synchronous cluster, with one write-set replicating at a time, wsrep_cert_interval returns a value of 1.0.

wsrep_cluster_conf_id

Total number of cluster membership changes happened.

Example Value 34
Location MySQL
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_cluster_conf_id';

+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| wsrep_cluster_conf_id | 34    |
+-----------------------+-------+

wsrep_cluster_size

Current number of members in the cluster.

Example Value 3
Location MySQL
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_cluster_size';

+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 15    |
+--------------------+-------+

wsrep_cluster_state_uuid

Provides the current State UUID. This is a unique identifier for the current state of the cluster and the sequence of changes it undergoes.

Example Value e2c9a15e-5485-11e00900-6bbb637e7211
Location MySQL
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_cluster_state_uuid';

+--------------------------+--------------------------------------+
| Variable_name            | Value                                |
+--------------------------+--------------------------------------+
| wsrep_cluster_state_uuid | e2c9a15e-5485-11e0-0800-6bbb637e7211 |
+--------------------------+--------------------------------------+

For more information on the state UUID, see wsrep API.

wsrep_cluster_status

Status of this cluster component. That is, whether the node is part of a PRIMARY or NON_PRIMARY component.

Example Value Primary
Location MySQL
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_cluster_status';

+----------------------+---------+
| Variable_name        | Value   |
+----------------------+---------+
| wsrep_cluster_status | Primary |
+----------------------+---------+

wsrep_cluster_weight

The total weight of the current members in the cluster. The value is counted as a sum of of pc.weight of the nodes in the current Primary Component.

Example Value 3
Location Galera
Initial Version 3.24

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_cluster_weight';

+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| wsrep_cluster_weight | 3     |
+----------------------+-------+

wsrep_commit_oooe

How often a transaction was committed out of order.

Example Value 0.000000
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_commit_oooe';

+-------------------+----------+
| Variable_name     | Value    |
+-------------------+----------+
| wsrep_commit_oooe | 0.000000 |
+-------------------+----------+

wsrep_commit_oool

No meaning.

Example Value 0.000000
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_commit_oool';

+-------------------+----------+
| Variable_name     | Value    |
+-------------------+----------+
| wsrep_commit_oool | 0.000000 |
+-------------------+----------+

wsrep_commit_window

Average distance between highest and lowest concurrently committed seqno.

Example Value 0.000000
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_commit_window';

+---------------------+----------+
| Variable_name       | Value    |
+---------------------+----------+
| wsrep_commit_window | 0.000000 |
+---------------------+----------+

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.

Example Value ON
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_connected';

+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| wsrep_connected | ON    |
+-----------------+-------+

wsrep_desync_count

Returns the number of operations in progress that require the node to temporarily desync from the cluster.

Example Value 0
Location Galera
Initial Version 3.8

Certain operations, such as DDL statements issued when wsrep_OSU_method is set to Rolling Schema Upgrade or when you enable wsrep_desync, cause the node to desync from the cluster. This status variable shows how many of these operations are currently running on the node. When all of these operations complete, the counter returns to its default value 0 and the node can sync back to the cluster.

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_desync_count';

+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_desync_count | 1     |
+--------------------+-------+

wsrep_evs_delayed

Provides a comma separated list of all the nodes this node has registered on its delayed list.

Example Value  
Location Galera
Initial Version 3.8

The node listing format is as follows:

uuid:address:count

This refers to the UUID and IP address of the delayed node, with a count of the number of entries it has on the delayed list.

wsrep_evs_evict_list

Lists the UUID’s of all nodes evicted from the cluster. Evicted nodes cannot rejoin the cluster until you restart their mysqld processes.

Example Value  
Location Galera
Initial Version 3.8

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_evs_evict_list';

+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| wsrep_evs_evict_list |       |
+----------------------+-------+

wsrep_evs_repl_latency

This status variable provides figures for the replication latency on group communication. It measures latency from the time point when a message is sent out to the time point when a message is received. As replication is a group operation, this essentially gives you the slowest ACK and longest RTT in the cluster.

Example Value 0.00243433/0.144033/0.581963/0.215724/13
Location Galera
Initial Version 3.0

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_evs_repl_latency';

+------------------------+------------------------------------------+
| Variable_name          | Value                                    |
+------------------------+------------------------------------------+
| wsrep_evs_repl_latency | 0.00243433/0.144022/0.591963/0.215824/13 |
+------------------------+------------------------------------------+

The units are in seconds. The format of the return value is:

Minimum / Average / Maximum / Standard Deviation / Sample Size

This variable periodically resets. You can control the reset interval using the evs.stats_report_period parameter. The default value is 1 minute.

wsrep_evs_state

Shows the internal state of the EVS Protocol.

Example Value  
Location Galera
Initial Version 3.8

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_evs_state';

+-----------------+-------------+
| Variable_name   | Value       |
+-----------------+-------------+
| wsrep_evs_state | OPERATIONAL |
+-----------------+-------------+

wsrep_flow_control_active

Whether flow control is currently active (replication paused) in the cluster.

Example Value false
Location Galera
Initial Version 3.31

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_flow_control_paused';

+---------------------------+----------+
| Variable_name             | Value    |
+---------------------------+----------+
| wsrep_flow_control_active | true     |
+---------------------------+----------+

wsrep_flow_control_paused

The fraction of time since the last FLUSH STATUS command that replication was paused due to flow control.

Example Value 0.174353
Location Galera
Initial Version  

Basically, this is how much the slave lag is slowing down the cluster.

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_flow_control_paused';

+---------------------------+----------+
| Variable_name             | Value    |
+---------------------------+----------+
| wsrep_flow_control_paused | 0.184353 |
+---------------------------+----------+

wsrep_flow_control_paused_ns

The total time spent in a paused state measured in nanoseconds.

Example Value 20222491180
Location Galera
Initial Version  

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_flow_control_paused_ns';

+------------------------------+-------------+
| Variable_name                | Value       |
+------------------------------+-------------+
| wsrep_flow_control_paused_ns | 20222491180 |
+------------------------------+-------------+

wsrep_flow_control_recv

Returns the number of FC_PAUSE events the node has received, including those the node has sent. Unlike most status variables, the counter for this one does not reset every time you run the query.

Example Value 11
Location Galera
Initial Version  

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_flow_control_recv';

+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| wsrep_flow_control_recv | 11    |
+-------------------------+-------+

wsrep_flow_control_requested

Whether the node has requested replication pause (received events queue too long)

Example Value false
Location Galera
Initial Version 3.31

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_flow_control_requested';

+------------------------------+-------+
| Variable_name                | Value |
+------------------------------+-------+
| wsrep_flow_control_requested | true  |
+------------------------------+-------+

wsrep_flow_control_sent

Returns the number of FC_PAUSE events the node has sent. Unlike most status variables, the counter for this one does not reset every time you run the query.

Example Value 7
Location Galera
Initial Version  

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_flow_control_sent';

+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| wsrep_flow_control_sent | 7     |
+-------------------------+-------+

wsrep_gmcast_segment

Returns cluster segment the node belongs to.

Example Value 3
Location Galera
Initial Version 3.31

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_gmcast_segment';

+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| wsrep_gmcast_segment | 0     |
+----------------------+-------+

wsrep_gcomm_uuid

Displays the group communications UUID.

Example Value 7e729708-605f-11e5-8ddd-8319a704b8c4
Location Galera
Initial Version 1.0

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_gcomm_uuid';

+------------------+--------------------------------------+
| Variable_name    | Value                                |
+------------------+--------------------------------------+
| wsrep_gcomm_uuid | 7e729708-605f-11e5-8ddd-8319a704b8c4 |
+------------------+--------------------------------------+

wsrep_incoming_addresses

Comma-separated list of incoming server addresses in the cluster component.

Example Value 10.0.0.1:3306,10.0.0.2:3306,undefined
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_incoming_addresses';

+--------------------------+--------------------------------------+
| Variable_name            | Value                                |
+--------------------------+--------------------------------------+
| wsrep_incoming_addresses | 10.0.0.1:3306,10.0.02:3306,undefined |
+--------------------------+--------------------------------------+

wsrep_ist_receive_status

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

wsrep_last_committed

The sequence number, or seqno, of the last committed transaction. See wsrep API.

Example Value 409745
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_last_committed';

+----------------------+--------+
| Variable_name        | Value  |
+----------------------+--------+
| wsrep_last_committed | 409745 |
+----------------------+--------+

For more information, see wsrep API.

wsrep_local_bf_aborts

Total number of local transactions that were aborted by slave transactions while in execution.

Example Value 960
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_bf_aborts';

+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| wsrep_local_bf_aborts | 960   |
+-----------------------+-------+

wsrep_local_cached_downto

The lowest sequence number, or seqno, in the write-set cache (GCache).

Example Value 18446744073709551615
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_cached_downto';

+---------------------------+----------------------+
| Variable_name             | Value                |
+---------------------------+----------------------+
| wsrep_local_cached_downto | 18446744073709551615 |
+---------------------------+----------------------+

wsrep_local_cert_failures

Total number of local transactions that failed certification test.

Example Value 333
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_cert_failures';

+---------------------------+-------+
| Variable_name             | Value |
+---------------------------+-------+
| wsrep_local_cert_failures | 333   |
+---------------------------+-------+

wsrep_local_commits

Total number of local transactions committed.

Example Value 14981
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_commits';

+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| wsrep_local_commits | 14981 |
+---------------------+-------+

wsrep_local_index

This node index in the cluster (base 0).

Example Value 1
Location MySQL
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_index';

+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| wsrep_local_index | 1     |
+-------------------+-------+

wsrep_local_recv_queue

Current (instantaneous) length of the recv queue.

Example Value 0
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_recv_queue';

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| wsrep_local_recv_queue | 0     |
+------------------------+-------+

wsrep_local_recv_queue_avg

Recv queue length averaged over interval since the last FLUSH STATUS command. Values considerably larger than 0.0 mean that the node cannot apply write-sets as fast as they are received and will generate a lot of replication throttling.

Example Value 3.348452
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_recv_queue_avg';

+----------------------------+----------+
| Variable_name              | Value    |
+----------------------------+----------+
| wsrep_local_recv_queue_avg | 3.348452 |
+----------------------------+----------+

wsrep_local_recv_queue_max

The maximum length of the recv queue since the last FLUSH STATUS command.

Example Value 10
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_recv_queue_max';

+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| wsrep_local_recv_queue_max | 10    |
+----------------------------+-------+

wsrep_local_recv_queue_min

The minimum length of the recv queue since the last FLUSH STATUS command.

Example Value 0
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_recv_queue_min';

+-----------------------------+-------+
| Variable_name               | Value |
+-----------------------------+-------+
| wsrep_local_recev_queue_min | 0     |
+-----------------------------+-------+

wsrep_local_replays

Total number of transaction replays due to asymmetric lock granularity.

Example Value 0
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_replays';

+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| wsrep_lcoal_replays | 0     |
+---------------------+-------+

wsrep_local_send_queue

Current (instantaneous) length of the send queue.

Example Value 1
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_send_queue';

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| wsrep_local_send_queue | 1     |
+------------------------+-------+

wsrep_local_send_queue_avg

Send queue length averaged over time since the last FLUSH STATUS command. Values considerably larger than 0.0 indicate replication throttling or network throughput issue.

Example Value 0.145000
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_send_queue_avg';

+----------------------------+----------+
| Variable_name              | Value    |
+----------------------------+----------+
| wsrep_local_send_queue_avg | 0.145000 |
+----------------------------+----------+

wsrep_local_send_queue_max

The maximum length of the send queue since the last FLUSH STATUS command.

Example Value 10
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_send_queue_max';

+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| wsrep_local_send_queue_max | 10    |
+----------------------------+-------+

wsrep_local_send_queue_min

The minimum length of the send queue since the last FLUSH STATUS command.

Example Value 0
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_send_queue_min';

+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| wsrep_local_send_queue_min | 0     |
+----------------------------+-------+

wsrep_local_state

Internal Galera Cluster FSM state number.

Example Value 4
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_state';

+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| wsrep_local_state | 4     |
+-------------------+-------+

For more information on the possible node states, see Node State Changes.

wsrep_local_state_comment

Human-readable explanation of the state.

Example Value Synced
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_state_comment';

+---------------------------+--------+
| Variable_name             | Value  |
+---------------------------+--------+
| wsrep_local_state_comment | Synced |
+---------------------------+--------+

wsrep_local_state_uuid

The UUID of the state stored on this node.

Example Value e2c9a15e-5385-11e0-0800-6bbb637e7211
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_local_state_uuid';

+------------------------+--------------------------------------+
| Variable_name          | Value                                |
+------------------------+--------------------------------------+
| wsrep_local_state_uuid | e2c9a15e-5485-11e0-0800-6bbb637e7211 |
+------------------------+--------------------------------------+

For more information on the state UUID, see wsrep API.

wsrep_open_connections

The number of open connection objects inside the wsrep provider.

Example Value 1
Location Galera
Initial Version 3.24

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_open_connections';

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| wsrep_open_connections | 1     |
+------------------------+-------+

wsrep_open_transactions

The number of locally running transactions which have been registered inside the wsrep provider. This means transactions which have made operations which have caused write set population to happen. Transactions which are read only are not counted.

Example Value 6
Location Galera
Initial Version 3.24

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_open_transactions';

+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| wsrep_open_transactions | 6     |
+-------------------------+-------+

wsrep_protocol_version

The version of the wsrep Protocol used.

Example Value 4
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_protocol_version';

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| wsrep_protocol_version | 4     |
+------------------------+-------+

The following table summarizes protocol versions and the galera version in which they were introduced:


Protocol version

Galera version
11 26.4.17
10 26.4.1
9 25.3.24
8 25.3.23
7 25.3.9
6 25.3.6
5 25.3.5

wsrep_provider_name

The name of the wsrep Provider.

Example Value Galera
Location MySQL
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_provider_name';

+---------------------+--------+
| Variable_name       | Value  |
+---------------------+--------+
| wsrep_provider_name | Galera |
+---------------------+--------+

wsrep_provider_vendor

The name of the wsrep Provider vendor.

Example Value Codership Oy <info@codership.com>
Location MySQL
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_provider_vendor';

+-----------------------+-----------------------------------+
| Variable_name         | Value                             |
+-----------------------+-----------------------------------+
| wsrep_provider_vendor | Codership Oy <info@codership.com> |
+-----------------------+-----------------------------------+

wsrep_provider_version

The name of the wsrep Provider version string.

Example Value 25.3.5-wheezy(rXXXX)
Location MySQL
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_provider_version';

+------------------------+----------------------+
| Variable_name          | Value                |
+------------------------+----------------------+
| wsrep_provider_version | 25.3.5-wheezy(rXXXX) |
+------------------------+----------------------+

wsrep_ready

Whether the server is ready to accept queries. If this status is OFF, almost all of the queries will fail with:

Example Value ON
Location MySQL
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

ERROR 1047 (08S01) Unknown Command

unless the wsrep_on session variable is set to 0.

SHOW STATUS LIKE 'wsrep_ready';

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wsrep_ready   | ON    |
+---------------+-------+

wsrep_received

Total number of write-sets received from other nodes.

Example Value 17831
Location MySQL
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_received';

+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| wsrep_received | 17831 |
+----------------+-------+

wsrep_received_bytes

Total size of write-sets received from other nodes.

Example Value 6637093
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_received_bytes';

+----------------------+---------+
| Variable_name        | Value   |
+----------------------+---------+
| wsrep_received_bytes | 6637093 |
+----------------------+---------+

wsrep_repl_data_bytes

Total size of data replicated.

Example Value 6526788
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_repl_data_bytes';

+-----------------------+---------+
| Variable_name         | Value   |
+-----------------------+---------+
| wsrep_repl_data_bytes | 6526788 |
+-----------------------+---------+

wsrep_repl_keys

Total number of keys replicated.

Example Value 797399
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_repl_keys';

+-----------------+--------+
| Variable_name   | Value  |
+-----------------+--------+
| wsrep_repl_keys | 797399 |
+-----------------+--------+

wsrep_repl_keys_bytes

Total size of keys replicated.

Example Value 11203721
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_repl_keys_bytes';

+-----------------------+----------+
| Variable_name         | Value    |
+-----------------------+----------+
| wsrep_repl_keys_bytes | 11203721 |
+-----------------------+----------+

wsrep_repl_other_bytes

Total size of other bits replicated.

Example Value 0
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_repl_other_bytes';

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| wsrep_repl_other_bytes | 0     |
+------------------------+-------+

wsrep_replicated

Total number of write-sets replicated (sent to other nodes).

Example Value 16109
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_replicated';

+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| wsrep_replicated | 16109 |
+------------------+-------+

wsrep_replicated_bytes

Total size of write-sets replicated.

Example Value 6526788
Location Galera
Initial Version ???

To see retrieve the value of this status variable, execute the SHOW STATUS statement like so:

SHOW STATUS LIKE 'wsrep_replicated_bytes';

+------------------------+---------+
| Variable_name          | Value   |
+------------------------+---------+
| wsrep_replicated_bytes | 6526788 |
+------------------------+---------+