检查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定义...
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. For a multithreaded replica, the replication_applier_status_...
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...
First you need to identify the replicated event that caused the error. Details of the error and the last successfully applied transaction are recorded in the Performance Schema tablereplication_applier_status_by_worker. You can use mysqlbinlog to retrieve and display the events that were logged ar...
| replication_applier_status_by_worker |###查看各个channel是否复制正常,以及并行复制work号,复制错误的code、SQL和时间 | replication_connection_configuration |###查看各个channel的连接配置信息:host、port、user、auto_position等 | replication_connection_status |###查看各个channel的连接信息 ...
end_log_pos 800. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any. Skip_Counter: 0 Exec_Master_Log_Pos: 646 Relay_Log_Space: 1303 Until_Condition: None ...
(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 ...
*performance_schema.replication_applier_status_by_worker:记录worker线程应用事务相关的状态(单主模式下,对于主要节点,该表中只有组复制通道group_replication_applier的记录,但具体的行数由系统变量slave_parallel_workers定义值决定。对于辅助节点,即复制远端事务的组成员,此表中会多记录组复制通道group_replication_recov...
| replication_applier_status | | replication_applier_status_by_coordinator | | replication_applier_status_by_worker | | replication_connection_configuration | | replication_connection_status | | replication_group_member_stats | | replication_group_members | ...