wsrep_last_committed

USAGE

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.

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

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    |
+----------------------+-------+

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

11.4 Enterprise

  • Not present.

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