pt-table-checsum details

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

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

Thanks for your reply Scott.