Hi,
you are right, option --single-transaction does not accquire any lock on
your innodb tables. Backup is fully on-line due to mvcc.
You should look for another reason of this behavior.
1/ What says 'show full processlist' when backup is running
2/ What says 'show engine innodb\G' when backup is running
2/ Is your db server stopped or very slow only? (you will see in 1/)
3/ If it's very slow
a/ what is your mysqldump config in my.cnf
b/ what about remote backup (mysqldump --host x.x.x.x --master-data
--single-transaction > dump.sql) which cause separating writes on
another box?
--
Filip Krejci <[EMAIL PROTECTED]>
Vini, vidi, Linux!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
