# pt-table-checksum doesn't hunt un-synced records

**URL:** <https://forums.percona.com/t/pt-table-checksum-doesnt-hunt-un-synced-records/2594>\
**Category:** Percona Toolkit\
**Created:** [November 16, 2012, 3:59am UTC](https://forums.percona.com/t/pt-table-checksum-doesnt-hunt-un-synced-records/2594 "2012-11-16T03:59:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mustu](https://avatars.discourse-cdn.com/v4/letter/m/c89c15/32.png) [@mustu](https://forums.percona.com/u/mustu)\
**Post date:** [November 16, 2012, 3:59am UTC](https://forums.percona.com/t/pt-table-checksum-doesnt-hunt-un-synced-records/2594/1 "2012-11-16T03:59:52Z")

</div>

Hi,

I’m working on investigating a row in my slave replica which isn’t synced with the master replica row. I’m using that slave for SELECT only.

I ran pt-table-checksum on my master replica. It checked the table on master & slave both but it couldn’t hunt the difference. I can clearly see the column records in the row on both instances and there is difference in many columns, only the first auto-increment column holds identical data else all columns differ.

Is it because the pt-table-checksum works on the index not on the actuall row in table? I couldn’t find any option in pt-table-checksum manual to force it to skip the index and actually checksum the row in table.

When I do manually checksum the table in mysql I get a difference. Why pt-table-checksum failed in this situation and how can I make it work?

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [November 23, 2012, 1:22am UTC](https://forums.percona.com/t/pt-table-checksum-doesnt-hunt-un-synced-records/2594/2 "2012-11-23T01:22:54Z")

</div>

Hi,

Can you provide commandline which you are running for checking checksum?

---

<div class="post-metadata">

**Author:** ![mustu](https://avatars.discourse-cdn.com/v4/letter/m/c89c15/32.png) [@mustu](https://forums.percona.com/u/mustu)\
**Post date:** [November 23, 2012, 6:22am UTC](https://forums.percona.com/t/pt-table-checksum-doesnt-hunt-un-synced-records/2594/3 "2012-11-23T06:22:46Z")

</div>

Hi,

pt-table-checksum --user root --password myPassword --databases myDatabase --tables myTable --nocheck-replication-filters