检查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_...
The query in the replication_applier_status_by_worker check assumes the replication_applier_status_by_worker table layout in mysql 8.0. Without this if you enable replication_applier_status_by_worker you'll receive the following error:
Bug #97540 errors not showing on ps.replication_applier_status_by_worker on single applier Submitted: 7 Nov 2019 17:59Modified: 12 Nov 2019 15:38 Reporter: Nuno Carvalho Email Updates: Status: Closed Impact on me: None Category: MySQL Server: Group ReplicationSeverity: S3 (Non-critical)...
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. ...
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...
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...
次のテーブルに、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_...