主从复制 - MySQL 主从延迟 300s 以上，求大神解答

Question

这几天碰到个问题，每天早上的十点到十点25分，十一点到十一点25分，十二点，从数据库的延迟会飙到很高，有时候达到300秒以上，查了binlog和自动脚本，都没什么特别严重的sql在拖速度。

补充：很长时间以来，这些时间段都会有比较明显的延迟，最近达到300s以上才发现有这个问题。

问：还有什么情况会导致延迟这么夸张？

Answer 1

How do you call SQL that is not particularly serious? If there are indeed automatic scripts at these three time points, change the running time of the script and take a look. If there is still a delay while the script is running, it is a problem with the script, but not necessarily caused by the SQL in the script.