replication_applier_status

This page is part of MariaDB's Documentation.

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

Topics on this page:

Overview
USAGE
DETAILS
- SYNONYMS
- SCHEMA
- PARAMETERS
- SKYSQL
- PRIVILEGES
EXAMPLES
ERROR HANDLING
FEATURE INTERACTION
RESPONSES
DIAGNOSIS
ISO 9075:2016
CHANGE HISTORY
RELATED TOPICS
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.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

USAGE

DETAILS

SYNONYMS

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.'
)

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

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.

replication_applier_status

Overview

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

RELATED TOPICS

EXTERNAL REFERENCES