Guest User

Untitled

a guest
Feb 17th, 2019
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. pt-table-checksum --ignore-databases mysql S=/tmp/5.6.22_3306_Master/data/mysql.sock --user=SlaveUser --password=1234
  2.  
  3. TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
  4. 07-21T16:47:35 0 0 8 1 0 0.008 test.Countries
  5. 07-21T16:47:35 0 0 0 1 0 0.006 test.Persons
  6.  
  7. SELECT db, tbl, SUM(this_cnt) AS total_rows, COUNT(*) AS chunks
  8. FROM percona.checksums
  9. WHERE (
  10. master_cnt <> this_cnt
  11. OR master_crc <> this_crc
  12. OR ISNULL(master_crc) <> ISNULL(this_crc))
  13. GROUP BY db, tbl;
Add Comment
Please, Sign In to add comment