GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

pt-table-checksum not recognizing perl regex for filtering tables

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-table-checksum not recognizing perl regex for filtering tables

    Hi,

    I basically have 2 queries.

    (1) I have a lot of temporary tables on master , which i am not replicating on slave , and i want to skip those tables during check , all table starts with "TMP_" , i tried all possible regex combination but the tool is not ignoring those tables.

    (2) I am trying to figure out the consistancy at slave and running the tool on master , i have got two ways through internet but don't know which is the best. Following are the two ways.

    (A.) perl /usr/bin/pt-table-checksum --set-vars innodb_lock_wait_timeout=50 --set-vars wait_timeout=50 --no-check-binlog-format --quiet
    (B) pt-table-checksum --replicate=test.checksum --replicate-check-only --set-vars innodb_lock_wait_timeout=50 --set-vars wait_timeout=50 --no-check-binlog-format

    Can some one help me in guiding me which is best for master/slave.

    Regards

    Suyash Jain
Working...
X