Home  >  Q&A  >  body text

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

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

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

问:还有什么情况会导致延迟这么夸张?

PHP中文网PHP中文网2720 days ago774

reply all(1)I'll reply

  • 巴扎黑

    巴扎黑2017-04-17 15:19:14

    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.

    reply
    0
  • Cancelreply