Hi,
I have 2 Mysql instances, Master & Slave. I added some rows to the slave so it is nor consistent with the master.
When I run pt-table-checksum I don’t see any DIFFS:
ii1> pt-table-checksum --empty-replicate-table -d test S=/tmp/5.6.22_3306_[B]Master[/B]/data/mysql.sock --user=SlaveUser --password=***
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
07-11T17:02:15 0 0 7 1 0 0.008 test.Countries
07-11T17:02:15 0 0 0 1 0 0.006 test.Persons
ii1>
ii1> pt-table-checksum --empty-replicate-table -d test S=/tmp/5.6.22_3310_[B]Slave[/B]/data/mysql.sock --user=SlaveUser --password=***
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
07-11T17:02:20 0 0 13 1 0 0.007 test.Countries
07-11T17:02:20 0 0 0 1 0 0.006 test.Persons
What am I missing?
Thanks