MySQL5.7复制延迟有什么办法解决

不知道大家之前对类似MySQL5.7复制延迟有什么办法解决的文章有无了解,今天我在这里给大家再简单的讲讲。感兴趣的话就一起来看看正文部分吧,相信看完MySQL5.7复制延迟有什么办法解决你一定会有所收获的。

一、描述
MySQL 5.7版本主从复制,批量时候显示延迟上万秒。

二,现象

 1, io使用率高
　　# iostat -dxm 1 1000
　　设备:,,,rrqm/s,wrqm/s,,r/s,,w/s,元人民币/s大敌;,wMB/s avgrq-sz avgqu-sz,等待,svctm %跑龙套
　　scd0,,,,,,,0.00,0.00,,0.00,0.00,0.00,,0.00,,0.00,,0.00,,0.000.00,0.00
　　的共识,,,,,,,0.00,,0.00,,0.00,0.00,0.00,,0.00,,0.00,,0.00,,0.000.00,0.00
　　一家,,,,,,,0.00,,96.00,0.00 - 2596.00,0.00,,8.54,,6.74,,1.33,,0.510.37,95.30
　　直流电压,,,,,,,0.00,,0.00,,0.00,0.00,0.00,,0.00,,0.00,,0.00,,0.000.00,0.00
　　vdd,,,,,,,0.00,,0.00,,0.0011.00,,0.00,,0.06,,11.64,0.00,,0.090.09,0.10
　　vde,,,,,,,0.00,,0.00,,0.00,7.00,0.00,,0.00,,0.00,,0.00,,0.000.00,0.00
　　氟乙烯,,,,,,,0.00,,0.00,,0.00,511.00,,0.00,,0.00,,0.00,,0.05,,0.090.09,4.60
　　vdg,,,,,,,0.00,,0.00,,0.00,511.00,,0.00,,0.00,,0.00,,0.05,,0.090.09,4.80
　　dm-0,,,,,,,0.00,0.00,,0.00,0.00,0.00,,0.00,,0.00,,0.00,,0.000.00,0.00
　　dm-1,,,,,,,0.00,0.00,,0.00,0.00,0.00,,0.00,,0.00,,0.00,,0.000.00,0.00
　　dm-2,,,,,,,0.00,0.00,,0.0034.00,,0.00,,0.23,,13.65,0.02,,0.590.38,1.30
　　dm-3,,,,,,,0.00,0.00,,0.00 - 2144.00,0.00,,8.38,,8.00,,1.40,,0.650.45,97.20
　　dm-4,,,,,,,0.00,0.00,,0.00,0.00,0.00,,0.00,,0.00,,0.00,,0.000.00,0.00
　　dm-5,,,,,,,0.00,0.00,,0.00,0.00,0.00,,0.00,,0.00,,0.00,,0.000.00,0.00
　　
　　2,dm3是中继日志和binlog分区
　　$ ls - l/dev/mapper
　　总0
　　lrwxrwxrwx 1根,根,7,7月23日23:20 backup-backup→. ./dm-0
　　crw-rw——1根根10,58 7月23日23:20控制
　　lrwxrwxrwx 1根,根,7,7月23日23:20 VG00-lv_root→. ./dm-4
　　lrwxrwxrwx 1根,根,7,7月23日23:20 zxmysql-zxdba→. ./dm-1
　　lrwxrwxrwx 1根,根,7,7月23日23:20 zxmysql-zxlog→. ./dm-3
　　
　　3,奴隶状态
　　mysql>显示奴隶状态\ G;
　　* * * * * * * * * * * * * * * * * * * * * * * * * * * 1。行  ***************************
　　,,,,,,,Slave_IO_State:排队掌握继电器日志事件
　　,,,,,,,,略.........................................
　　,,,,,,,Connect_Retry: 60
　　,,,,,,Master_Log_File: mysql-bin.011494
　　,,,,Read_Master_Log_Pos: 21037034
　　,,,,,,,Relay_Log_File: relay-log.001904
　　,,,,,,,Relay_Log_Pos: 3154097
　　,,,Relay_Master_Log_File: mysql-bin.011494
　　,,,,,,Slave_IO_Running:是的
　　,,,,,Slave_SQL_Running:是的
　　,,,,,,,Replicate_Do_DB:
　　,,,,,Replicate_Ignore_DB:
　　,null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
　　null
MySQL5.7复制延迟有什么办法解决