Hi All, I am planning to take mysqldump on slave running innodb engine.
I going to use the below command /usr/bin/mysqldump --user=root --password=xxxx --flush-logs --all-databases --master-data=2 --single-transaction > alldbdump.sql Before doing the mysqldump, should i stop the slave or the above command is enough, please let know, also please let me know if any other option i can use to speed up mysqldump. regards anandkl
