If you just do MySQL dump without any parameters, it locks tables and consumes a lot of memory. If you want to avoid it and you have InnoDB, best way to do it is to add 
single-transaction (run in single transaction) and q (dump one row at once) properties, for example like:mysqldump -q --single-transaction -u login -ppassword db > dump.sql
 
No comments:
Post a Comment