是的,经过分析,业务那边在删除一个大表数据,从库单线程处理不过来,且io性能也比较低,造成堆积
[mysql@mysql192-168-0-36 /data/mysqldata1/relaylog]iostat -x /dev/sda2 2 9
Linux 2.6.18-164.el5 (mysql192-168-0-36) 2013年12月23日
avg-cpu: %user %nice %system %iowait %steal %idle
7.98 0.00 3.34 3.75 0.00 84.93
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda2 6.02 1050.99 93.36 111.82 5026.43 13932.71 92.40 0.44 16.13 2.18 44.72
avg-cpu: %user %nice %system %iowait %steal %idle
4.44 0.00 2.75 6.65 0.00 86.16
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda2 9.00 495.00 193.00 285.50 6324.00 21136.00 57.39 1.36 2.82 1.92 91.75
avg-cpu: %user %nice %system %iowait %steal %idle
4.40 0.00 2.59 7.22 0.00 85.79
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda2 1.00 261.00 216.50 143.50 7008.00 9600.00 46.13 1.43 3.68 2.55 91.85
avg-cpu: %user %nice %system %iowait %steal %idle
4.50 0.00 2.37 6.31 0.00 86.82
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda2 2.00 154.50 211.50 73.50 6896.00 5268.00 42.68 1.20 4.59 3.20 91.20
avg-cpu: %user %nice %system %iowait %steal %idle
3.37 0.00 1.50 6.37 0.00 88.75
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda2 9.00 252.00 200.00 179.00 6480.00 12580.00 50.29 1.22 3.22 2.43 91.95
avg-cpu: %user %nice %system %iowait %steal %idle
4.65 0.00 2.62 7.03 0.00 85.69
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda2 0.00 187.50 181.50 267.00 5984.00 19148.00 56.04 1.25 2.79 2.05 92.10
avg-cpu: %user %nice %system %iowait %steal %idle
5.15 0.00 3.53 6.40 0.00 84.92
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda2 1.00 273.13 200.50 77.11 6360.20 6185.07 45.19 1.19 4.31 3.32 92.04
avg-cpu: %user %nice %system %iowait %steal %idle
3.47 0.00 2.06 7.91 0.00 86.56
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda2 11.00 173.00 191.00 320.00 6072.00 19328.00 49.71 2.38 4.66 1.86 95.10
avg-cpu: %user %nice %system %iowait %steal %idle
4.15 0.00 1.75 6.59 0.00 87.51
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda2 1.00 97.00 200.00 155.00 6296.00 11160.00 49.17 1.22 3.43 2.65 94.25