mysqldump and centos?

Question

MySQL

There is a vps on Centos.
When you run the script:
mysqldump -u$MUSER -p$MPASS -A > $DPATCH
tar czfP $DBGZIP $DPATCH
rm -rf $DPATCH
ncftpput -m -u$FTPU -p$FTPP $FTPS $FTPF $DBGZIP
connection to the database is lost on the work site. What could be the problem? How to overcome?

Answer 1

stackoverflow.com/questions/104612/run-mysqldump-w...
dba.stackexchange.com/questions/19532/safest-way-t...
by default mysqldump blocks access to all tables

Answer 2

During the dump, the table is apparently locked, and the site is waiting for the lock to be removed.
nice options like this -n 19 ionice -c2 -n7 mysqldump --quick --single-transaction can often help