galera_group_members

This page is part of MariaDB's MariaDB Documentation.

The parent of this page is: Performance Schema

Topics on this page:

Overview
DETAILS
- SCHEMA
CHANGE HISTORY

Overview

In 10.6 ES:: A description for this Performance-schema Table has not yet been added to this Documentation.

In 10.6 CS, 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:: Not present

In 10.5 ES, 10.4 ES:: Not present

DETAILS

SCHEMA

CREATE TABLE `galera_group_members` (
  `wsrep_node_id` char(36) NOT NULL COMMENT 'Unique node ID (UUID)',
  `wsrep_local_index` int(10) unsigned NOT NULL COMMENT 'Index of this node in the Galera cluster nodes table',
  `wsrep_cluster_state_uuid` char(36) NOT NULL COMMENT 'The UUID of the cluster',
  `wsrep_local_state_uuid` char(36) NOT NULL COMMENT 'The UUID of the state stored on this node',
  `wsrep_last_applied` bigint(20) unsigned NOT NULL COMMENT 'Sequence number of the last applied transaction',
  `wsrep_last_committed` bigint(20) unsigned NOT NULL COMMENT 'Sequence number of the last committed transaction',
  `wsrep_replicated` bigint(20) unsigned NOT NULL COMMENT 'Total number of write-sets replicated',
  `wsrep_replicated_bytes` bigint(20) unsigned NOT NULL COMMENT 'Total size of write-sets replicated (in bytes)',
  `wsrep_received` bigint(20) unsigned NOT NULL COMMENT 'Total number of write-sets received',
  `wsrep_received_bytes` bigint(20) unsigned NOT NULL COMMENT 'Total size of write-sets received (in bytes)',
  `wsrep_local_bf_aborts` bigint(20) unsigned NOT NULL COMMENT 'Total number of local transactions that were aborted by slave transactions while in execution',
  `wsrep_local_commits` bigint(20) unsigned NOT NULL COMMENT 'Total number of local transactions committed',
  `wsrep_local_cert_failures` bigint(20) unsigned NOT NULL COMMENT 'Total number of local transactions that failed certification test',
  `wsrep_apply_window` double NOT NULL COMMENT 'Average distance between the highest and lowest concurrently applied seqno',
  `wsrep_commit_window` double NOT NULL COMMENT 'Average distance between the highest and lowest concurrently committed seqno'
)

CHANGE HISTORY

Release Series	History
10.6 Enterprise	Added in MariaDB Enterprise Server 10.6.4-1. Schema changed in MariaDB Enterprise Server 10.6.5-2: ... CREATE TABLE `galera_group_members` ( `wsrep_node_id` char(36) NOT NULL COMMENT 'Unique node ID (UUID)', `wsrep_local_index` int(10) unsigned NOT NULL COMMENT 'Unique node ID (UUID)', `wsrep_cluster_state_uuid` char(36) NOT NULL COMMENT 'Index of this node in the Galera cluster nodes table', `wsrep_local_state_uuid` char(36) NOT NULL COMMENT 'The UUID of the cluster', `wsrep_last_applied` bigint(20) unsigned NOT NULL COMMENT 'The UUID of the state stored on this node', `wsrep_last_committed` bigint(20) unsigned NOT NULL COMMENT 'Sequence number of the last applied transaction', `wsrep_replicated` bigint(20) unsigned NOT NULL COMMENT 'Sequence number of the last committed transaction', `wsrep_replicated_bytes` bigint(20) unsigned NOT NULL COMMENT 'Total number of write-sets replicated', `wsrep_received` bigint(20) unsigned NOT NULL COMMENT 'Total size of write-sets replicated (in bytes)', `wsrep_received_bytes` bigint(20) unsigned NOT NULL COMMENT 'Total number of write-sets received', `wsrep_local_bf_aborts` bigint(20) unsigned NOT NULL COMMENT 'Total size of write-sets received (in bytes)', `wsrep_local_commits` bigint(20) unsigned NOT NULL COMMENT 'Total number of local transactions that were aborted by slave transactions while in execution', `wsrep_local_cert_failures` bigint(20) unsigned NOT NULL COMMENT 'Total number of local transactions committed', `wsrep_apply_window` bigint(20)double NOT NULL COMMENT 'Total number of local transactions that failed certification test', `wsrep_commit_window` bigint(20) NOT NULLdouble NOT NULL COMMENT 'Average distance between the highest and lowest concurrently committed seqno' )
10.6 Community	Not present.
10.5 Enterprise	Not present.
10.5 Community	Not present.
10.4 Enterprise	Not present.
10.4 Community	Not present.
10.3 Enterprise	Not present.
10.3 Community	Not present.
10.2 Enterprise	Not present.
10.2 Community	Not present.

Release Series	History
10.6 Enterprise	Added in MariaDB Enterprise Server 10.6.4-1. Schema changed in MariaDB Enterprise Server 10.6.5-2: ... CREATE TABLE `galera_group_members` ( `wsrep_node_id` char(36) NOT NULL COMMENT 'Unique node ID (UUID)', `wsrep_local_index` int(10) unsigned NOT NULL COMMENT 'Unique node ID (UUID)', `wsrep_cluster_state_uuid` char(36) NOT NULL COMMENT 'Index of this node in the Galera cluster nodes table', `wsrep_local_state_uuid` char(36) NOT NULL COMMENT 'The UUID of the cluster', `wsrep_last_applied` bigint(20) unsigned NOT NULL COMMENT 'The UUID of the state stored on this node', `wsrep_last_committed` bigint(20) unsigned NOT NULL COMMENT 'Sequence number of the last applied transaction', `wsrep_replicated` bigint(20) unsigned NOT NULL COMMENT 'Sequence number of the last committed transaction', `wsrep_replicated_bytes` bigint(20) unsigned NOT NULL COMMENT 'Total number of write-sets replicated', `wsrep_received` bigint(20) unsigned NOT NULL COMMENT 'Total size of write-sets replicated (in bytes)', `wsrep_received_bytes` bigint(20) unsigned NOT NULL COMMENT 'Total number of write-sets received', `wsrep_local_bf_aborts` bigint(20) unsigned NOT NULL COMMENT 'Total size of write-sets received (in bytes)', `wsrep_local_commits` bigint(20) unsigned NOT NULL COMMENT 'Total number of local transactions that were aborted by slave transactions while in execution', `wsrep_local_cert_failures` bigint(20) unsigned NOT NULL COMMENT 'Total number of local transactions committed', `wsrep_apply_window` bigint(20)double NOT NULL COMMENT 'Total number of local transactions that failed certification test', `wsrep_commit_window` bigint(20) NOT NULLdouble NOT NULL COMMENT 'Average distance between the highest and lowest concurrently committed seqno' )
10.5 Enterprise	Not present.
10.4 Enterprise	Not present.