replication_applier_status

This page is part of MariaDB's MariaDB Documentation.

The parent of this page is: Performance Schema for MariaDB Enterprise Server

Topics on this page:

Overview
DETAILS
- SCHEMA
CHANGE HISTORY

Overview

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

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

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

In 10.4 ES:: Not present

DETAILS

SCHEMA

CREATE TABLE `replication_applier_status` (
  `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'The replication channel name.',
  `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'Shows ON when the replication channel''s applier threads are active or idle, OFF means that the applier threads are not active.',
  `REMAINING_DELAY` int(10) unsigned DEFAULT NULL COMMENT 'Seconds the replica needs to wait to reach the desired delay from master.',
  `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL COMMENT 'The number of retries that were made because the replication SQL thread failed to apply a transaction.'
)

CHANGE HISTORY

Release Series	History
10.6 Enterprise	Schema changed in MariaDB Enterprise Server 10.6.4-1: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` char(64varchar(256) NOT NULL, `SERVICE_STATE` enum('ON','OFF') NOT NULL, `REMAINING_DELAY` int(10) unsigned DEFAULT NULL, `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL ) Schema changed in MariaDB Enterprise Server 10.6.5-2: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'The replication channel name.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'Shows ON when the replication channel''s applier threads are active or idle, OFF means that the applier threads are not active.', `REMAINING_DELAY` int(10) unsigned DEFAULT NULL COMMENT 'Seconds the replica needs to wait to reach the desired delay from master.', `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL COMMENT 'The number of retries that were made because the replication SQL thread failed to apply a transaction.' )
10.6 Community	Schema changed in MariaDB Community Server 10.6.0: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` char(64varchar(256) NOT NULL, `SERVICE_STATE` enum('ON','OFF') NOT NULL, `REMAINING_DELAY` int(10) unsigned DEFAULT NULL, `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL ) Schema changed in MariaDB Community Server 10.6.5: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'The replication channel name.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'Shows ON when the replication channel''s applier threads are active or idle, OFF means that the applier threads are not active.', `REMAINING_DELAY` int(10) unsigned DEFAULT NULL COMMENT 'Seconds the replica needs to wait to reach the desired delay from master.', `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL COMMENT 'The number of retries that were made because the replication SQL thread failed to apply a transaction.' )
10.5 Enterprise	Added in MariaDB Enterprise Server 10.5.3-1. Schema changed in MariaDB Enterprise Server 10.5.6-4: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` char(64) CHARACTER SET utf8 NOT NULL, `SERVICE_STATE` enum('ON','OFF') NOT NULL, `REMAINING_DELAY` int(10) unsigned DEFAULT NULL, `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL ) Schema changed in MariaDB Enterprise Server 10.5.8-5: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` char(64) CHARACTER SET utf8 NOT NULL, `SERVICE_STATE` enum('ON','OFF') NOT NULL, `REMAINING_DELAY` int(10) unsigned DEFAULT NULL, `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL ) Schema changed in MariaDB Enterprise Server 10.5.13-9: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` char(64) NOT NULL COMMENT 'The replication channel name.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'Shows ON when the replication channel''s applier threads are active or idle, OFF means that the applier threads are not active.', `REMAINING_DELAY` int(10) unsigned DEFAULT NULL COMMENT 'Desired replica delay functionality not supported by MariaDB. Always 0.', `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL COMMENT 'The number of retries that were made because the replication SQL thread failed to apply a transaction.' )
10.5 Community	Added in MariaDB Community Server 10.5.2. Schema changed in MariaDB Community Server 10.5.13: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` char(64) NOT NULL COMMENT 'The replication channel name.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'Shows ON when the replication channel''s applier threads are active or idle, OFF means that the applier threads are not active.', `REMAINING_DELAY` int(10) unsigned DEFAULT NULL COMMENT 'Desired replica delay functionality not supported by MariaDB. Always 0.', `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL COMMENT 'The number of retries that were made because the replication SQL thread failed to apply a transaction.' )
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	Schema changed in MariaDB Enterprise Server 10.6.4-1: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` char(64varchar(256) NOT NULL, `SERVICE_STATE` enum('ON','OFF') NOT NULL, `REMAINING_DELAY` int(10) unsigned DEFAULT NULL, `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL ) Schema changed in MariaDB Enterprise Server 10.6.5-2: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'The replication channel name.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'Shows ON when the replication channel''s applier threads are active or idle, OFF means that the applier threads are not active.', `REMAINING_DELAY` int(10) unsigned DEFAULT NULL COMMENT 'Seconds the replica needs to wait to reach the desired delay from master.', `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL COMMENT 'The number of retries that were made because the replication SQL thread failed to apply a transaction.' )
10.5 Enterprise	Added in MariaDB Enterprise Server 10.5.3-1. Schema changed in MariaDB Enterprise Server 10.5.6-4: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` char(64) CHARACTER SET utf8 NOT NULL, `SERVICE_STATE` enum('ON','OFF') NOT NULL, `REMAINING_DELAY` int(10) unsigned DEFAULT NULL, `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL ) Schema changed in MariaDB Enterprise Server 10.5.8-5: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` char(64) CHARACTER SET utf8 NOT NULL, `SERVICE_STATE` enum('ON','OFF') NOT NULL, `REMAINING_DELAY` int(10) unsigned DEFAULT NULL, `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL ) Schema changed in MariaDB Enterprise Server 10.5.13-9: ... CREATE TABLE `replication_applier_status` ( `CHANNEL_NAME` char(64) NOT NULL COMMENT 'The replication channel name.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'Shows ON when the replication channel''s applier threads are active or idle, OFF means that the applier threads are not active.', `REMAINING_DELAY` int(10) unsigned DEFAULT NULL COMMENT 'Desired replica delay functionality not supported by MariaDB. Always 0.', `COUNT_TRANSACTIONS_RETRIES` bigint(20) unsigned NOT NULL COMMENT 'The number of retries that were made because the replication SQL thread failed to apply a transaction.' )
10.4 Enterprise	Not present.