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

pt-table-checksum

MonuMonu EntrantCurrent User Role Beginner
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.

Comments

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.