replication_applier_status_by_coordinator

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_by_coordinator` (
  `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'Replication channel name.',
  `THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'The SQL/coordinator thread ID.',
  `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'ON (thread exists and is active or idle) or OFF (thread no longer exists).',
  `LAST_ERROR_NUMBER` int(11) NOT NULL COMMENT 'Last error number that caused the SQL/coordinator thread to stop.',
  `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL COMMENT 'Last error message that caused the SQL/coordinator thread to stop.',
  `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp that shows when the most recent SQL/coordinator error occured.',
  `LAST_SEEN_TRANSACTION` char(57) NOT NULL COMMENT 'The transaction the worker has last seen.',
  `LAST_TRANS_RETRY_COUNT` int(11) NOT NULL COMMENT 'Total number of retries attempted by last transaction.'
)

CHANGE HISTORY

Release Series	History
10.6 Enterprise	Schema changed in MariaDB Enterprise Server 10.6.4-1: ... CREATE TABLE `replication_applier_status_by_coordinator` ( `CHANNEL_NAME` char(64varchar(256) NOT NULL, `THREAD_ID` bigint(20) unsigned DEFAULT NULL, `SERVICE_STATE` enum('ON','OFF') NOT NULL, `LAST_ERROR_NUMBER` int(11) NOT NULL, `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL, `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `LAST_SEEN_TRANSACTION` char(57) NOT NULL, `LAST_TRANS_RETRY_COUNT` int(11) NOT NULL ) Schema changed in MariaDB Enterprise Server 10.6.5-2: ... CREATE TABLE `replication_applier_status_by_coordinator` ( `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'Replication channel name.', `THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'The SQL/coordinator thread ID.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'ON (thread exists and is active or idle) or OFF (thread no longer exists).', `LAST_ERROR_NUMBER` int(11) NOT NULL COMMENT 'Last error number that caused the SQL/coordinator thread to stop.', `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL COMMENT 'Last error message that caused the SQL/coordinator thread to stop.', `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),() COMMENT 'Timestamp that shows when the most recent SQL/coordinator error occured.', `LAST_SEEN_TRANSACTION` char(57) NOT NULL COMMENT 'The transaction the worker has last seen.', `LAST_TRANS_RETRY_COUNT` int(11) NOT NULL COMMENT 'Total number of retries attempted by last transaction.' )
10.6 Community	Schema changed in MariaDB Community Server 10.6.0: ... CREATE TABLE `replication_applier_status_by_coordinator` ( `CHANNEL_NAME` char(64varchar(256) NOT NULL, `THREAD_ID` bigint(20) unsigned DEFAULT NULL, `SERVICE_STATE` enum('ON','OFF') NOT NULL, `LAST_ERROR_NUMBER` int(11) NOT NULL, `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL, `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `LAST_SEEN_TRANSACTION` char(57) NOT NULL, `LAST_TRANS_RETRY_COUNT` int(11) NOT NULL ) Schema changed in MariaDB Community Server 10.6.5: ... CREATE TABLE `replication_applier_status_by_coordinator` ( `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'Replication channel name.', `THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'The SQL/coordinator thread ID.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'ON (thread exists and is active or idle) or OFF (thread no longer exists).', `LAST_ERROR_NUMBER` int(11) NOT NULL COMMENT 'Last error number that caused the SQL/coordinator thread to stop.', `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL COMMENT 'Last error message that caused the SQL/coordinator thread to stop.', `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),() COMMENT 'Timestamp that shows when the most recent SQL/coordinator error occured.', `LAST_SEEN_TRANSACTION` char(57) NOT NULL COMMENT 'The transaction the worker has last seen.', `LAST_TRANS_RETRY_COUNT` int(11) NOT NULL COMMENT 'Total number of retries attempted by last 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_by_coordinator` ( `CHANNEL_NAME` char(64) CHARACTER SET utf8 NOT NULL, `THREAD_ID` bigint(20) unsigned DEFAULT NULL, `SERVICE_STATE` enum('ON','OFF') NOT NULL, `LAST_ERROR_NUMBER` int(11) NOT NULL, `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL, `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) Schema changed in MariaDB Enterprise Server 10.5.8-5: ... CREATE TABLE `replication_applier_status_by_coordinator` ( `CHANNEL_NAME` char(64) CHARACTER SET utf8 NOT NULL, `THREAD_ID` bigint(20) unsigned DEFAULT NULL, `SERVICE_STATE` enum('ON','OFF') NOT NULL, `LAST_ERROR_NUMBER` int(11) NOT NULL, `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL, `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) Schema changed in MariaDB Enterprise Server 10.5.13-9: ... CREATE TABLE `replication_applier_status_by_coordinator` ( `CHANNEL_NAME` char(64) NOT NULL COMMENT 'Replication channel name.', `THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'The SQL/coordinator thread ID.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'ON (thread exists and is active or idle) or OFF (thread no longer exists).', `LAST_ERROR_NUMBER` int(11) NOT NULL COMMENT 'Last error number that caused the SQL/coordinator thread to stop.', `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL COMMENT 'Last error message that caused the SQL/coordinator thread to stop.', `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp that shows when the most recent SQL/coordinator error occured.' )
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_by_coordinator` ( `CHANNEL_NAME` char(64) NOT NULL COMMENT 'Replication channel name.', `THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'The SQL/coordinator thread ID.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'ON (thread exists and is active or idle) or OFF (thread no longer exists).', `LAST_ERROR_NUMBER` int(11) NOT NULL COMMENT 'Last error number that caused the SQL/coordinator thread to stop.', `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL COMMENT 'Last error message that caused the SQL/coordinator thread to stop.', `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp that shows when the most recent SQL/coordinator error occured.' )
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_by_coordinator page in the SkySQL Documentation.