GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

pt-table-checksum is not cheking all tables

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?
    Last edited by HTF1; 06-07-2013, 03:32 AM.

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

    Comment

    Working...
    X