pt-table-checksum is not cheking all tables

Hi,

It seems that pt-table-checksum is not checking all tables, details:

I’m using replication filters:

replicate-wild-do-table = test_slave.%
replicate-rewrite-db = test->test_slave

  • so I’ve created symlink as follow:
    ln -s /var/lib/mysql/test /var/lib/mysql/test_slave
    chown mysql:mysql /var/lib/mysql/test_slave

Command:
pt-table-checksum --host=localhost --databases=test --max-load=Threads_connected:25 --no-check-replication-filters

mysql> SELECT COUNT() FROM information_schema.TABLES WHERE TABLE_SCHEMA = ‘test_slave’;
±---------+
| COUNT(
) |
±---------+
| 145 |
±---------+
1 row in set (0.00 sec)

mysql> SELECT COUNT() FROM percona.checksums;
±---------+
| COUNT(
)|
±---------+
| 40|
±---------+
1 row in set (0.00 sec)

I’m aware that checksums are done based in part on a unique value and there is ~10 tables with no primary keys and unique keys however is there any reason why only 40 tables are checked?

Hi, Can we have the full output of pt-table-checksum command? It might help to identify the issue. Thanks.