Re: mysqldump on slave.
The version is 5.0.40, i will running on slave db and during night time not much of activites. regards anandkl On 7/8/07, Alex Arul Lurthu <[EMAIL PROTECTED]> wrote: You havent mentioned which version of mysql your are on. If on an older version i would recommend the option --opt. Also if you are running a dump using single-transaction option on a loaded system with writes, things might slow down significantly due to different versions of rows which the server needs to maintain due to the dump. Thanks Alex On 7/6/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > 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= --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 >
Re: mysqldump on slave.
You havent mentioned which version of mysql your are on. If on an older version i would recommend the option --opt. Also if you are running a dump using single-transaction option on a loaded system with writes, things might slow down significantly due to different versions of rows which the server needs to maintain due to the dump. Thanks Alex On 7/6/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: 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= --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
mysqldump on slave.
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= --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