| replication_applier_configuration | | 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 | +---+...
| replication_applier_configuration | | 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 | +---+...
The replication_applier_status_by_worker table has these columns: CHANNEL_NAME The replication channel which this row is displaying. There is always a default replication channel, and more replication channels can be added. See Section 16.2.2, “Replication Channels” for more information. WORK...
replication_applier_status 这个表显示从库SQL线程的状态总信息,现在生产中一般都开启了多线程复制,多线程复制下SQL线程状态主要看replication_applier_status_by_coordinator table和replication_applier_status_by_worker这两张表。 replication_applier_status_by_coordinator 对于多线程复制,从库使用了多个复制线程(workthr...
replication_applier_status_by_worker:应用从主服务器接收事务的线程的当前状态,提供有关应用程序线程或使用多线程复制时每个工作线程应用的事务信息。 使用这些表,可以监控相应线程处理的最后一个事务以及该线程当前正在处理的事务的信息,包括: 事务的 GTID。
replication_applier_status_by_worker mysql> select * from performance_schema.replication_applier_status_by_worker\G *** 8. row *** CHANNEL_NAME: WORKER_ID: 8 THREAD_ID: NULL SERVICE_STATE: OFF LAST_SEEN_TRANSACTION: c50d7f49-ef3f-11ea-949c-287...
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 b...
通过replication_applier_status_by_worker可以看到worker进程的工作情况: mysql>select*from replication_applier_status_by_worker;+---+---+---+---+---+---+---+---+|CHANNEL_NAME|WORKER_ID|THREAD_ID|SERVICE_STATE|LAST_SEEN_TRANSACTION|LAST_ERROR_NUMBER|LAST_ERROR_MESSAGE|LAST_ERROR_TIMESTAMP...
Replication_applier_status 记录从库的普通事务执行状态(复制组中的复制状态信息) Replication_applier_status_by_coordinator 使用多线程复制, 记录coordinator线程的工作状态 Replication_applier_status_by_worker 单线程则记录一条worker_id=0; 如果多线程记录 worker线程状态 ...
6.replication_applier_status_by_worker:记录多线程复制的work线程状态(performance_schema库) 7.replication_connection_configuration:记录从库连接主库的配置参数,在执行change master时插入和更(performance_schema库) 8.replication_connection_status:记录从库io线程的连接状态信息(performance_schema库) ...