Not the answer you need?
Register and ask your own question!

pt-table-sync slow on first sync

pugganpuggan EntrantCurrent User Role Beginner
If i have 2 servers, that the main server have around 400 000 rows in the table i want to sync, and at the other server its still empty.
Why dose it take hours to do this first sync?
Its alot faster to do a mysqldump of it, transfer that file, and import that file.

The conclusion of "I have 400 000 rows in my primary key at server 1, and 0 rows on server 2, I think i need to insert all rows in to server 2",
sounds easy, so why is it taking over 10 times longer then a mysqldump/transfer/import?

Where can i Look for bottlenecks?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.