MySQL备库延迟排查

1、备库执行

show slave status\G;

Last_SQL_Error

2、备库执行

select * from performance_schema.replication_applier_status_by_worker limit 5 \G;

mysqladmin：https://blog.csdn.net/carefree2005/article/details/113772015

3、复制信息表详解

https://weread.qq.com/web/reader/4aa3250071a74c1d4aacadek2a3327002582a38a4a932bf?

select * from mysql.slave_master_info\G;

select * from mysql.slave_relay_log_info\G;

内存表

https://blog.csdn.net/wang0907/article/details/126769011