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

pt-table-checksum is not cheking all tables

HTF1HTF1 ContributorInactive User Role Beginner
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?

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi, Can we have the full output of pt-table-checksum command? It might help to identify the issue. Thanks.
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.