草庐IT

MySQL 主从同步延迟监控

MySQL5.7和8.0支持通过replication_applier_status表获同步延迟时间,当从库出现延迟后,该表中的字段REMAINING_DELAY记录延迟秒数,当没有延迟时,该字段值为NULL,官方对该字段介绍如下:REMAINING_DELAY IfthereplicaiswaitingforDESIRED_DELAYsecondstopasssincethesourceappliedanevent,thisfieldcontainsthenumberofdelaysecondsremaining.Atothertimes,thisfieldisNULL.(TheDESIRE

MySQL 主从同步延迟监控

MySQL5.7和8.0支持通过replication_applier_status表获同步延迟时间,当从库出现延迟后,该表中的字段REMAINING_DELAY记录延迟秒数,当没有延迟时,该字段值为NULL,官方对该字段介绍如下:REMAINING_DELAY IfthereplicaiswaitingforDESIRED_DELAYsecondstopasssincethesourceappliedanevent,thisfieldcontainsthenumberofdelaysecondsremaining.Atothertimes,thisfieldisNULL.(TheDESIRE