Cannot schedule event Rows_query, relay-log name ./mysql-relay-bin.000081, position 849140440 to Worker thread because its size 16777231 exceeds 16777216 of slave_pending_jobs_size_max.
mysql> show global variables like '%slave_pending_jobs_size_max%';
+-----------------------------+----------+
| Variable_name | Value |
+-----------------------------+----------+
| slave_pending_jobs_size_max | 16777216 |
+-----------------------------+----------+
#32M
stop slave;
set global slave_pending_jobs_size_max=33554432;
start slave;
show slave status\G;
本文介绍了一种在MySQL中遇到的事件调度问题:由于事件大小超过了slave_pending_jobs_size_max的限制而无法调度到工作线程。文章提供了调整slave_pending_jobs_size_max参数的方法以解决问题,并附带了具体的SQL命令。
766

被折叠的 条评论
为什么被折叠?



