Waiting for Slave Workers to free pending events

简介:

今天处理一个主备延迟的问题,看到有这个状态

Slave_SQL_Running_State : Waiting for Slave Workers to free pending events

除了大事务外,这个等待状态的意思是:
当事件的大小超过了slave_pending_jobs_size_max的大小,而当时间大小低于slave_pending_jobs_size_max的限制时调度器才会恢复调度。这种情况只会发生在slave_parallel_workers大于0时。

stop slave;
set global slave_parallel_workers=0;
start slave;

参考

https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/slave-sql-thread-states.html

相关文章
|
10月前
|
SQL 关系型数据库 MySQL
Lock wait timeout exceeded; try restarting transaction解决方案
在测试程序时,打的断点怎么都跳不进去,console一直报 “Lock wait timeout exceeded; try restarting transaction”
301 0
|
关系型数据库 MySQL
MySQL里Wating for Slave workers to free pending events到底在等什么
MySQL里Wating for Slave workers to free pending events到底在等什么
165 0
Timeout waiting to lock artifact cache ....
Timeout waiting to lock artifact cache ....
Timeout waiting to lock artifact cache ....
|
SQL 监控 关系型数据库
mysql主从复制出现Waiting for Slave Worker to release partition
本文分享mysql主从复制出现Waiting for Slave Worker to release partition
mysql主从复制出现Waiting for Slave Worker to release partition
|
.NET Windows 开发框架
|
SQL XML 数据格式