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?