# pt-table-checksum

**URL:** <https://forums.percona.com/t/pt-table-checksum/5227>\
**Category:** Percona Toolkit\
**Created:** [November 23, 2016, 1:12am UTC](https://forums.percona.com/t/pt-table-checksum/5227 "2016-11-23T01:12:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Monu](https://avatars.discourse-cdn.com/v4/letter/m/6f9a4e/32.png) [@Monu](https://forums.percona.com/u/Monu)\
**Post date:** [November 23, 2016, 1:12am UTC](https://forums.percona.com/t/pt-table-checksum/5227/1 "2016-11-23T01:12:59Z")

</div>

Hello,

I have a replication setup 1 master and 2 slaves. version of percona is 5.6 and size of database is 550+ GB.  
There is some size differences between master and slave1. some tables have small size of .ibd files than master and some tables are partitioned (700+ partition).  
Slave was setup using physical files (not using mysqldump).RAM = 500GB  
The following details is given of one of big table and it is very important table of our database :-

On master :-

count(\*) = 816746410  
Total size of table = 261.326690673828 GB  
data\_length of table = 128.425338745117 GB  
index\_length of table = 132.901351928711 GB  
Rows = 770959074  
Avg\_row\_length = 178

Data\_free (Data fragmentation) = 5315231744 (approx 5GB)

on slave :-

count(\*) = 816754414  
Total size of table = 134.960708618164 GB  
data\_length of table = 66.542572021484 GB  
index\_length of table = 68.418136596680 GB  
Rows = 390371601  
Avg\_row\_length = 183

Data\_free (Data fragmentation) = 5350883328 (approx 5GB)

please provide the solution and how can i check data consistency OR there is no matter on size because count is same. I have knowledge pt-table-checksum but i don’t get any opportunity to use that.

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [March 30, 2017, 1:46am UTC](https://forums.percona.com/t/pt-table-checksum/5227/2 "2017-03-30T01:46:48Z")

</div>

In order to check data consistency through pt-table-checksum you can refer to my post [URL][https://www.percona.com/blog/2015/08/12/mysql-replication-primer-with-pt-table-checksum-and-pt-table-sync/[/URL]](https://www.percona.com/blog/2015/08/12/mysql-replication-primer-with-pt-table-checksum-and-pt-table-sync/%5B/URL%5D)