tar and ssh large file
You can insert the pv command into your pipeline to get a report of how many bytes have been transferred, like this:
tar -czpf - ./ --exclude mysql mysql-bin* mysql.sock |
pv |
ssh -lroot xxx.xx.xxx.xx tar -xzpf - -C /var/lib/mysql
This will give you output like this, including the total number of bytes and the current transfer rate:
202MB 0:00:13 [ 17MB/s] [ <=> ]
You can also just run du -sh on the destination directory.