这几天碰到个问题,每天早上的十点到十点25分,十一点到十一点25分,十二点,从数据库的延迟会飙到很高,有时候达到300秒以上,查了binlog和自动脚本,都没什么特别严重的sql在拖速度。
补充:很长时间以来,这些时间段都会有比较明显的延迟,最近达到300s以上才发现有这个问题。
问:还有什么情况会导致延迟这么夸张?
巴扎黑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.