wsrep_last_committed

Overview

Sequence Number (seqno) of last committed transaction.

See also: Status Variables in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

DETAILS

Sequence Number or seqno is an integer used in Global Transaction ID's used to identify the position of a transaction in a sequence of transcations. The Galera Replication plugin that manages replication for Cluster Nodes uses the seqno in the global ordering of write-sets applied from the cluster.

This status variable provides the Sequence Number (seqno) of the last committed transaction.

EXAMPLES

Use the SHOW STATUS statement to show the seqno of the last committed transaction:

SHOW STATUS LIKE "wsrep_last_committed";
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| wsrep_last_committed | 16    |
+----------------------+-------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

EXTERNAL REFERENCES