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.
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 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 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 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 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). Note that this is an average measure. You will not see acute changes in this variable.
| Example Value | 23.888889 |
| Location | Galera |
| Initial Version | ??? |
To 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 retrieve the value of this status variable, execute the SHOW STATUS statement like so:
SHOW STATUS LIKE 'wsrep_cert_index_size';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| wsrep_cert_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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 replica lag is slowing down the cluster.
To 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 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 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 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 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 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 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 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 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 replica transactions while in execution.
| Example Value | 960 |
| Location | Galera |
| Initial Version | ??? |
To 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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:
ERROR 1047 (08S01) Unknown Command
unless the wsrep_on session variable is set to 0.
| Example Value | ON |
| Location | MySQL |
| Initial Version | ??? |
To retrieve the value of this status variable, execute the SHOW STATUS statement like so:
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 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 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 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 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 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 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 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 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 |
+------------------------+---------+
