replication_applier_status_by_worker

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_by_worker` (
  `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'Name of replication channel through which the transaction is received.',
  `THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'Thread_Id as displayed in the performance_schema.threads table for thread with name ''thread/sql/rpl_parallel_thread''. THREAD_ID will be NULL when worker threads are stopped due to error/force stop.',
  `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'Whether or not the thread is running.',
  `LAST_SEEN_TRANSACTION` char(57) NOT NULL COMMENT 'Last GTID executed by worker',
  `LAST_ERROR_NUMBER` int(11) NOT NULL COMMENT 'Last Error that occurred on a particular worker.',
  `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL COMMENT 'Last error specific message.',
  `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Time stamp of last error.',
  `WORKER_IDLE_TIME` bigint(20) unsigned NOT NULL COMMENT 'Total idle time in seconds that the worker thread has spent waiting for work from SQL thread.',
  `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_worker` ( `CHANNEL_NAME` char(64) collate utf8_general_civarchar(256) NOT NULL, `WORKERTHREAD_ID` bigint(20) unsigned NODEFAULT NULL, `THREAD_ID` bigint unsigned, `SERVICE_STATE` enum('ON', 'OFF') NOT NULL, `LAST_SEEN_TRANSACTION` char(57) NOT NULL, `LAST_ERROR_NUMBER` integer(11) NOT NULL, `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL, `LAST_ERROR_TIMESTAMP` timestamp(0 NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `WORKER_IDLE_TIME` bigint(20) unsigned 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_worker` ( `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'Name of replication channel through which the transaction is received.', `THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'Thread_Id as displayed in the performance_schema.threads table for thread with name ''thread/sql/rpl_parallel_thread''. THREAD_ID will be NULL when worker threads are stopped due to error/force stop.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'Whether or not the thread is running.', `LAST_SEEN_TRANSACTION` char(57) NOT NULL COMMENT 'Last GTID executed by worker', `LAST_ERROR_NUMBER` int(11) NOT NULL COMMENT 'Last Error that occurred on a particular worker.', `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL COMMENT 'Last error specific message.', `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),() COMMENT 'Time stamp of last error.', `WORKER_IDLE_TIME` bigint(20) unsigned NOT NULL COMMENT 'Total idle time in seconds that the worker thread has spent waiting for work from SQL thread.', `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_worker` ( `CHANNEL_NAME` char(64) collate utf8_general_civarchar(256) NOT NULL, `WORKERTHREAD_ID` bigint(20) unsigned NODEFAULT NULL, `THREAD_ID` bigint unsigned, `SERVICE_STATE` enum('ON', 'OFF') NOT NULL, `LAST_SEEN_TRANSACTION` char(57) NOT NULL, `LAST_ERROR_NUMBER` integer(11) NOT NULL, `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL, `LAST_ERROR_TIMESTAMP` timestamp(0 NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `WORKER_IDLE_TIME` bigint(20) unsigned 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_worker` ( `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'Name of replication channel through which the transaction is received.', `THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'Thread_Id as displayed in the performance_schema.threads table for thread with name ''thread/sql/rpl_parallel_thread''. THREAD_ID will be NULL when worker threads are stopped due to error/force stop.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'Whether or not the thread is running.', `LAST_SEEN_TRANSACTION` char(57) NOT NULL COMMENT 'Last GTID executed by worker', `LAST_ERROR_NUMBER` int(11) NOT NULL COMMENT 'Last Error that occurred on a particular worker.', `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL COMMENT 'Last error specific message.', `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),() COMMENT 'Time stamp of last error.', `WORKER_IDLE_TIME` bigint(20) unsigned NOT NULL COMMENT 'Total idle time in seconds that the worker thread has spent waiting for work from SQL thread.', `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.13-9: ... CREATE TABLE `replication_applier_status_by_worker` ( `CHANNEL_NAME` char(64) collate utf8_general_ci NOT NULL comment 'Name of replication channel through which the transaction is received.', `WORKER_ID` bigint unsigned NOT NULL comment 'worker identifier., `THREAD_ID` bigint unsigned, `SERVICE_STATE` enum('ON', 'OFF') NOT NULL, `LAST_SEEN_TRANSACTION` char(57) NOT NULL, `LAST_ERROR_NUMBER` integer NOT NULL comment 'thread_id as displayed in the performance_schema.threads table for thread with name ''thread/sql/rpl_parallel_thread''. thread_id will be null when worker threads are stopped due to error/force stop.', `SERVICE_STATE` enum('ON', 'OFF') NOT NULL comment 'Whether or not the thread is running.', `LAST_SEEN_TRANSACTION` char(57) NOT NULL comment 'Last GTID executed by worker', `LAST_ERROR_NUMBER` integer NOT NULL comment 'last error that occurred on a particular worker.', `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL comment 'Last error specific message.', `LAST_ERROR_TIMESTAMP` timestamp(0) NOT NULL comment 'Time stamp of last error.' )
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_worker` ( `CHANNEL_NAME` char(64) collate utf8_general_ci NOT NULL comment 'Name of replication channel through which the transaction is received.', `WORKER_ID` bigint unsigned NOT NULL comment 'worker identifier., `THREAD_ID` bigint unsigned, `SERVICE_STATE` enum('ON', 'OFF') NOT NULL, `LAST_SEEN_TRANSACTION` char(57) NOT NULL, `LAST_ERROR_NUMBER` integer NOT NULL comment 'thread_id as displayed in the performance_schema.threads table for thread with name ''thread/sql/rpl_parallel_thread''. thread_id will be null when worker threads are stopped due to error/force stop.', `SERVICE_STATE` enum('ON', 'OFF') NOT NULL comment 'Whether or not the thread is running.', `LAST_SEEN_TRANSACTION` char(57) NOT NULL comment 'Last GTID executed by worker', `LAST_ERROR_NUMBER` integer NOT NULL comment 'last error that occurred on a particular worker.', `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL comment 'Last error specific message.', `LAST_ERROR_TIMESTAMP` timestamp(0) NOT NULL comment 'Time stamp of last error.' )
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_by_worker` ( `CHANNEL_NAME` char(64) collate utf8_general_civarchar(256) NOT NULL, `WORKERTHREAD_ID` bigint(20) unsigned NODEFAULT NULL, `THREAD_ID` bigint unsigned, `SERVICE_STATE` enum('ON', 'OFF') NOT NULL, `LAST_SEEN_TRANSACTION` char(57) NOT NULL, `LAST_ERROR_NUMBER` integer(11) NOT NULL, `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL, `LAST_ERROR_TIMESTAMP` timestamp(0 NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `WORKER_IDLE_TIME` bigint(20) unsigned 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_worker` ( `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'Name of replication channel through which the transaction is received.', `THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'Thread_Id as displayed in the performance_schema.threads table for thread with name ''thread/sql/rpl_parallel_thread''. THREAD_ID will be NULL when worker threads are stopped due to error/force stop.', `SERVICE_STATE` enum('ON','OFF') NOT NULL COMMENT 'Whether or not the thread is running.', `LAST_SEEN_TRANSACTION` char(57) NOT NULL COMMENT 'Last GTID executed by worker', `LAST_ERROR_NUMBER` int(11) NOT NULL COMMENT 'Last Error that occurred on a particular worker.', `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL COMMENT 'Last error specific message.', `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),() COMMENT 'Time stamp of last error.', `WORKER_IDLE_TIME` bigint(20) unsigned NOT NULL COMMENT 'Total idle time in seconds that the worker thread has spent waiting for work from SQL thread.', `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.13-9: ... CREATE TABLE `replication_applier_status_by_worker` ( `CHANNEL_NAME` char(64) collate utf8_general_ci NOT NULL comment 'Name of replication channel through which the transaction is received.', `WORKER_ID` bigint unsigned NOT NULL comment 'worker identifier., `THREAD_ID` bigint unsigned, `SERVICE_STATE` enum('ON', 'OFF') NOT NULL, `LAST_SEEN_TRANSACTION` char(57) NOT NULL, `LAST_ERROR_NUMBER` integer NOT NULL comment 'thread_id as displayed in the performance_schema.threads table for thread with name ''thread/sql/rpl_parallel_thread''. thread_id will be null when worker threads are stopped due to error/force stop.', `SERVICE_STATE` enum('ON', 'OFF') NOT NULL comment 'Whether or not the thread is running.', `LAST_SEEN_TRANSACTION` char(57) NOT NULL comment 'Last GTID executed by worker', `LAST_ERROR_NUMBER` integer NOT NULL comment 'last error that occurred on a particular worker.', `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL comment 'Last error specific message.', `LAST_ERROR_TIMESTAMP` timestamp(0) NOT NULL comment 'Time stamp of last error.' )
10.4 Enterprise	Not present.