Sample Header Ad - 728x90

pt-table-checksum show wrong DIFF

-1 votes
1 answer
485 views
I'm try to use pt-table-checksum tool. I have Master/Slave tables, and I add some rows to the slave to check it. pt-table-checksum --ignore-databases mysql S=/tmp/5.6.22_3306_Master/data/mysql.sock --user=SlaveUser --password=1234 produce this result: TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE 07-21T16:47:35 0 0 8 1 0 0.008 test.Countries 07-21T16:47:35 0 0 0 1 0 0.006 test.Persons When I run this query (SELECT * FROM percona.checksums WHERE db not like 'mysql';) on the **slave** I can see the difference: enter image description here How I can see the right result and the diff with pt-table-checksum? Thanks!
Asked by ElazarG (1 rep)
Jul 21, 2016, 01:53 PM
Last activity: Oct 30, 2019, 08:02 PM