mysql优化 - 如何确认MySQL replication真正的复制延迟是多少

Question

mysql replication 慢的真正原因是什么？

Answer 1

Write a script to record the binlog position of the master and slave in a few seconds
The slowness may be due to the network or other reasons, and this is dynamic. Even if it is fast enough,
The program cannot rely on the consistency of the master and slave. For consistency, you can only use the main query