innodb tables should use single transaction
Hi,
For better performance and prevent long time locks on big tables, mysqldump should be called with "--single-transaction" instead of "--lock-tables" on innodb tables.
(from redmine: created on 2008-03-26)
Edited by Guillaume Subiron