检查performance_schema.replication_applier_status_by_worker表的状态信息: performance_schema.replication_applier_status_by_worker表提供了关于MySQL复制应用者(Applier)的状态信息,这对于诊断复制问题非常有用。你可以使用以下SQL查询来检查该表的内容: sql SELECT * FROM performance_schema.replication_applier_status_...
replication_applier_status_by_worker表列名含义对应show slave status输出字段名 CHANNEL_NAME显示复制通道名称Channel_Name WORKER_ID该通道下在该表中的工作线程标识符(与mysql.slave_worker_info表中的工作线程id列值相同),按照数值范围1~slave_parallel_workers系统参数定义的值,依次编号(如slave_parallel_workers定义...
25.12.11.6 The replication_applier_status_by_worker Table If the replica is not multithreaded, this table shows the status of the applier thread. Otherwise, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the worker threads. ...
replication_applier_status_by_worker; If the statement returns zero, the transaction has not yet been committed, either because it is still being processed, or because the worker thread was stopped while it was being processed. If the statement returns nonzero, the transaction has been...
(the default value) the error is not show, the same x.test produces the output: ``` SELECT * FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME = "group_replication_recovery"; CHANNEL_NAME group_replication_recovery WORKER_ID 0 THREAD_ID NULL SERVICE_STATE OFF ...
10.11.5 The replication_applier_status_by_worker Table This table provides details of the transactions handled by applier threads on a replica or Group Replication group member. For a single-threaded replica, data is shown for the replica's single applier thread. For a multithreaded re...
29.12.11.9 The replication_applier_status_by_worker Table This table provides details of the transactions handled by applier threads on a replica or Group Replication group member. For a single-threaded replica, data is shown for the replica's single applier thread. For a multithreaded replica, ...
次のテーブルに、replication_applier_status_by_worker カラムと SHOW REPLICA | SLAVE STATUS カラムの対応を示します。 replication_applier_status_by_worker カラム SHOW REPLICA | SLAVE STATUS カラム WORKER_ID なし THREAD_ID なし SERVICE_STATE なし LAST_ERROR_NUMBER Last_SQL_Errno LAST_ERROR_...