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

**URL:** <https://forums.percona.com/t/pt-table-checksum-not-recognizing-perl-regex-for-filtering-tables/3554>\
**Category:** Percona Toolkit\
**Created:** [June 18, 2014, 9:02am UTC](https://forums.percona.com/t/pt-table-checksum-not-recognizing-perl-regex-for-filtering-tables/3554 "2014-06-18T09:02:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jainsuyash](https://avatars.discourse-cdn.com/v4/letter/j/5daacb/32.png) [@jainsuyash](https://forums.percona.com/u/jainsuyash)\
**Post date:** [June 18, 2014, 9:02am UTC](https://forums.percona.com/t/pt-table-checksum-not-recognizing-perl-regex-for-filtering-tables/3554/1 "2014-06-18T09:02:28Z")

</div>

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
