SELECT * FROM information_schema.`PROCESSLIST` WHERE command<>'sleep';
Reading event from the relay log
SHOW relaylog EVENTS IN 'mysql-relay-bin.000059' FROM 890792001 LIMIT 500 ;
查到是SET @@SESSION.GTID_NEXT= 'ANONYMOUS'事件卡住
# 卡在这个SET @@SESSION.GTID_NEXT= 'ANONYMOUS' ,不知道是啥,把这个event跳过
STOP SLAVE ;
SET GLOBAL sql_slave_skip_counter=1;
START SLAVE;
再次查看从库和主库之间差距是不是有缩小
SELECT * FROM information_schema.`PROCESSLIST` WHERE command<>'sleep';
详细解读: