Sample Header Ad - 728x90

pt-table-checksum to compare two tables?

2 votes
1 answer
1774 views
I'm trying to find a way of comparing two tables in two databases (master and slave), as I have applied some slightly different settings to one, and need to see what affect it has (if any) on the data etc. Ordinarily I would use MySQL Utilities dbcompare which has worked well in the past, but this doesn't seem to have the option for a single table, and mysqldiff is too limited. So I downloaded percona-toolkit to my Debian Server (the slave) and am looking at pt-table-checksum. But the Page on the Percona website is very little help, instead filled with all manner of options, but seemingly no examples. I set up a test schema, with one table, and diffent data. So far I have got as far as: pt-table-checksum h=1.2.3.4,P=3306,u=xxxx,p=xxxx, -h1.2.3.5 --databases=test --tables=t1 --no-check-binlog-format (apparently there is some problem with Row Based Replication [?] hence --no-check-binlog-format) But this returned: # A software update is available: # * The current version for Percona::Toolkit is 2.2.14. TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE 08-17T09:54:32 0 1 4 1 0 0.291 test.t1 Not exactly what I had in mind. Am I missing something, or have I completely misunderstood what pt-table-checksum does? I'm not sure why I didn't get the latest version either. I ran sudo apt-get update followed by sudo apt-get install percona-toolkit. (as you may have gathered, I'm not really a Linux person)
Asked by IGGt (2276 rep)
Aug 17, 2016, 09:17 AM
Last activity: Oct 5, 2018, 06:16 AM