Performance Schema replication_applier_status_by_worker Table

You are viewing an old version of this article. View the current version here.
MariaDB starting with 10.6.0

The replication_applier_status_by_worker table was added in MariaDB 10.6.0.

The Performance Schema replication_applier_status_by_worker table displays replica worker thread specific information.

It contains the following fields.

ColumnDescription
CHANNEL_NAMEName of replication channel through which the transaction is received.
THREAD_IDThread_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_STATEWhether or not the thread is running.
LAST_SEEN_TRANSACTIONLast GTID executed by worker
LAST_ERROR_NUMBERLast Error that occurred on a particular worker.
LAST_ERROR_MESSAGELast error specific message.
LAST_ERROR_TIMESTAMPTime stamp of last error.
WORKER_IDLE_TIMETotal idle time in seconds that the worker thread has spent waiting for work from SQL thread.
LAST_TRANS_RETRY_COUNTTotal number of retries attempted by last transaction.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.