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

pt-table-checsum details

krishnakrishna ContributorInactive User Role Beginner
Hi Team,

We have performed pt-table-check sum on specific server and understand that a Database by name Percona gets created under which checksums table will be added once we run the pt-table-checksum.

There are different fields in the checksum table. Could you please clarify the actual meaning of the below fields:
this_crc,
this_cnt,
master_crc,
master_cnt,
chunk,
chunk_index,
lower_boundary,
upper_boundary.

Best Regards,
Krishna

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    Hi Krishna;


    TABLE
    The database and table that differs from the master.

    CHUNK
    The chunk number of the table that differs from the master.

    CNT_DIFF
    The number of chunk rows on the replica minus the number of chunk rows on the master.

    CRC_DIFF
    1 if the CRC of the chunk on the replica is different than the CRC of the chunk on the master, else 0.

    CHUNK_INDEX
    The index used to chunk the table.

    LOWER_BOUNDARY
    The index values that define the lower boundary of the chunk.

    UPPER_BOUNDARY
    The index values that define the upper boundary of the chunk.

    http://www.percona.com/doc/percona-t...-checksum.html


    This does not tell you the exact meaning of each of the table fields, however it describes most of the terminology which you can extrapolate to the table fields.

    -Scott
  • krishnakrishna Contributor Inactive User Role Beginner
    Thanks for your reply Scott.
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.