avgrq-sz showd by iostat suddenly reduced from 32 to 2 while using xtrabackup

23 views

Skip to first unread message

weixiang zhai

unread,

Nov 24, 2011, 9:26:39 PM11/24/11

to Percona Discussion

my step :
sudo /usr/bin/innobackupex-1.5.1 --user=root --tmpdir=/bak/mysqlbak/
20111122/ --stream=tar /bak/mysqlbak/20111122/ --slave-info 2>/bak/
mysqlbak/20111122/xtrabackup.log | /home/yinfeng.zwx/pv-1.2.0/pv -L6m
| gzip > /bak/mysqlbak/20111122/xtrabak__20111122_1536.tar.gz

$ls -lh ibdata*
lrwxrwxrwx 1 root root 23 Nov 22 10:34 ibdata1 -> /u02/mysql/data/
ibdata1
lrwxrwxrwx 1 root root 23 Nov 22 10:34 ibdata2 -> /u02/mysql/data/
ibdata2

avgrq-sz changed from 32 to 2 suddenly before finish backup ibdata1

sda12 0.99 0.00 381.19 0.00 6083.17 0.00
31.92 0.02 0.05 0.05 1.78
sda12 3.00 0.00 385.00 0.00 6144.00 0.00
31.92 0.03 0.08 0.08 2.90
sda12 1.00 0.00 385.00 0.00 6144.00 0.00
31.92 0.03 0.07 0.07 2.60
sda12 2.00 1.00 386.00 2.00 6144.00 12.00
31.73 0.03 0.09 0.09 3.40
sda12 1.00 0.00 385.00 0.00 6144.00 0.00
31.92 0.02 0.06 0.06 2.30
sda12 1.00 0.00 981.00 0.00 6170.00 0.00
12.58 0.05 0.05 0.05 4.60
sda12 0.00 0.00 6023.00 0.00 6023.00 0.00
2.00 0.15 0.02 0.02 14.90
sda12 0.00 0.00 6142.00 0.00 6142.00 0.00
2.00 0.15 0.03 0.03 15.50
sda12 0.00 1.00 6144.00 2.00 6144.00 12.00
2.00 0.16 0.03 0.03 16.30
sda12 0.00 0.00 5807.00 0.00 5807.00 0.00
2.00 0.17 0.03 0.03 17.00
sda12 0.00 0.00 6223.76 0.00 6223.76 0.00
2.00 0.16 0.02 0.03 15.64
sda12 0.00 0.00 5995.00 0.00 5995.00 0.00
2.00 0.15 0.03 0.03 15.20
sda12 0.00 0.00 5823.00 0.00 5823.00 0.00
2.00 0.16 0.03 0.03 16.20
sda12 0.00 4.00 6300.00 3.00 6300.00 28.00
2.01 0.15 0.02 0.02 15.50
sda12 0.00 0.00 6144.00 0.00 6144.00 0.00
2.00 0.15 0.03 0.03 15.50
sda12 0.00 0.00 5721.00 0.00 5721.00 0.00
2.00 0.15 0.03 0.03 14.70
sda12 0.00 0.00 6420.00 0.00 6420.00 0.00
2.00 0.17 0.03 0.03 16.70