replication_applier_status

This page is part of MariaDB's Enterprise Documentation.

The parent of this page is: Performance Schema

Topics on this page:

Overview
DETAILS
- SCHEMA
CHANGE HISTORY
EXTERNAL REFERENCES

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.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:: 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.

EXTERNAL REFERENCES

Information specific to MariaDB SkySQL can be found on the replication_applier_status page in the SkySQL Documentation.