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; ```

目录
打赏
0
0
0
0
9124
分享
相关文章
MySQL里Wating for Slave workers to free pending events到底在等什么
MySQL里Wating for Slave workers to free pending events到底在等什么
225 0
Streams AQ: qmn coordinator waiting for slave to start等待事件
       Streams AQ: qmn coordinator waiting for slave to start等待事件很少见到,今天在查看一个客户的AWR报告中发现了这个等待事件,AWR报告的TOP如下:                        ...
2528 0
【转】BUFFER CACHE WAIT EVENTS
文章转自:http://oracleinaction.com/buffer-cache-wait-events/
672 0
【Oracle】Master Note for Parallel Execution Wait Events
关于并行的等待事件汇总: Scope This is intended as a reference for anyone involved in database tuning.
1359 0
Timeout waiting to lock artifact cache ....
Timeout waiting to lock artifact cache ....
Timeout waiting to lock artifact cache ....
AI助理

你好,我是AI助理

可以解答问题、推荐解决方案等