Amar
unread,Jun 1, 2012, 6:01:58 AM6/1/12Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Percona Discussion
Hi,
I am using pt-table-checksum for checking data consistency, the
problem I am facing is that its skipping the tables which got correct
rows and showing this output
05-31T19:58:16 Skipping table database.table because on the master it
would be checksummed in one chunk but on these replicas it has too
many rows:
26017 rows on slave1
27213 rows on slave2
27100 rows on slave3
The current chunk size limit is 22440 rows (chunk size=11220 * chunk
size limit=2.0).
If I do count on database.table it shows 22101 rows on all slaves
including master.
This is what I am running
pt-table-checksum h=localhost,P=3306,u=user,p=pass --nocheck-
replication-filters --lock-wait-timeout=120 --recursion-method
dsn=localhost,D=percona,t=dsns --ignore-tables
table1,table2,table3,table4 --databases-regex ^database
Any help is appreciated.
Thanks,