MySQL Sync Status

Exec_master_log_pos:the position of the last event executed by the SQL thread from the Master ' s binary Log (relay_master_ Log_file). (Relay_master_log_file, Exec_master_log_pos) in the Master's binary Log corresponds to (Relay_log_file, Relay_log_pos) in The relay log.
From the literal sense, (Relay_master_log_file, Exec_master_log_pos) and (Relay_log_file, Relay_log_pos) are corresponding, They represent the location of the statements being executed in the SQL process in slave, indicating the state of synchronization between Slave and master. When Relay_master_log_file and Master_log_file are the same in slave, and Read_master_log_pos and Exec_master_log_pos are exactly the same, Indicates that slave and master are in a fully synchronized state.

Relay_log_file, Relay_log_pos used for slave to do master.

　　

MySQL Sync Status