Peer review maatkits mk-parallel-dump and mk-parallel-restore usage?

Im trying to make use of maatkit as a means of dumping a database and then restoring to another database.

For dumps: mk-parallel-dump --user abc --password xyz --databases $db --base-dir 开发者_StackOverflow社区/tmp/dump

For restore: mk-parallel-restore --create-databases --user abc --password xyz --database devdb /tmp/dump

My question is, is my logic and understanding correct, and would it be ok to do it like this.

Kind Regards Brent

---

Yes, that should work as expected. However, do some benchmarks on the time using Mysqldump and Maakit's parallel dump. It is not always faster in our experience.

---

You can also add ionice -c1 -n7 in order to rise the run level of the command to do.

You can also tell how many tread you want to allocate to your command, like dumping or restoring 3 tables at the same time.

More stuff here