Not the answer you need?
Register and ask your own question!

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

jainsuyashjainsuyash EntrantCurrent User Role Beginner
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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.