近期,发现一个MySQL从节点提示同步异常。执行show replica status都被挂起。 重要信息 1初步分析 1.1 连接情况 当前连接的线程情况 当前连接中,运行的 16 个 worker 线程。其中: 4 个状态为Waiting for preceding transaction to commit 11 个状态为Applying batch of row changes 1 个状态为Executing event 线程等...
mysql从库延迟太大, SQL线程和IO线程都是Running的, 但延迟有5天左右. SQL线程状态为:applying batch of row changes (delete) 解析相关relay log得到正在执行的事务信息 代码语言:javascript 代码运行次数:0 运行 AI代码解释 mysqlbinlog-vvv--base64-output=decode-row relay.xxxxx--start-position|more 查找该...
| 62 | system user | | mc | Query | 507 | Applying batch of row changes (write) | NULL | | 63 | system user | | mc | Query | 517 | Applying batch of row changes (write) | NULL | | 64 | system user | | mc | Query | 508 | Applying batch of row changes (write) | N...
christophe offroy September 06, 2023 02:59AM Re: [REPLICATION] : replica hangs on Applying batch of row changes (update) 534 kaiqiang wu November 20, 2023 05:43AM Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respect...
Applying batch of row changes (update) | replace into test.testpri2(a,b,c) values(144,144,144) | | 116 | system user | | NULL | Query | 2356 | Waiting for preceding transaction to commit | NULL | | 117 | system user | | NULL | Query | 2356 | Waiting for preceding ...
mysql>UPDATEperformance_schema.setup_instrumentsSETENABLED='YES'->WHERENAMELIKE'stage/sql/Applying batch of row changes%'; Wait for some events to be processed by the replication applier thread and then check progress by looking into theevents_stages_currenttable. For example to get progress forup...
Applying batch of row changes (write)|YES|YES||stage/sql/Applying batch of row changes (update)|YES|YES||stage/sql/Applying batch of row changes (delete)|YES|YES||stage/innodb/alter table (end)|YES|YES||stage/innodb/alter table (flush)|YES|YES||stage/innodb/alter table (insert)|YES...
[REPLICATION] : replica hangs on Applying batch of row changes (update) 1,229 christophe offroy 09/06/2023 02:59AM Re: [REPLICATION] : replica hangs on Applying batch of row changes (update) 549 kaiqiang wu 11/20/2023 05:43AM
changes at a low pace in a single transaction. The cluster hang started soon after the batch job had committed in the first node. The hang was caused by this one big transaction taking a long time to apply in secondary nodes. The cluster was apparently choking for a too big bite.The...
Writes the DDL changes to the schema change topic, including all necessary DROP… and CREATE… DDL statements.This happens if applicable. Scans the database tables and generates CREATE events on the relevant table-specific Kafka topics for each row. Commits the transaction. Records the completed ...