# pt-table-sync slow on first sync

**URL:** <https://forums.percona.com/t/pt-table-sync-slow-on-first-sync/4629>\
**Category:** Percona Toolkit\
**Created:** [December 23, 2015, 9:51am UTC](https://forums.percona.com/t/pt-table-sync-slow-on-first-sync/4629 "2015-12-23T09:51:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![puggan](https://avatars.discourse-cdn.com/v4/letter/p/779978/32.png) [@puggan](https://forums.percona.com/u/puggan)\
**Post date:** [December 23, 2015, 9:51am UTC](https://forums.percona.com/t/pt-table-sync-slow-on-first-sync/4629/1 "2015-12-23T09:51:53Z")

</div>

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?