Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pt-table-checksum --ignore-databases mysql S=/tmp/5.6.22_3306_Master/data/mysql.sock --user=SlaveUser --password=1234
- 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
- SELECT db, tbl, SUM(this_cnt) AS total_rows, COUNT(*) AS chunks
- FROM percona.checksums
- WHERE (
- master_cnt <> this_cnt
- OR master_crc <> this_crc
- OR ISNULL(master_crc) <> ISNULL(this_crc))
- GROUP BY db, tbl;
Add Comment
Please, Sign In to add comment