Questions tagged [pt-table-checksum]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers

Replication between master and slave is running, but still there is a one row difference in a few tables when checked with pt-table-checksum

This is the master status mysql> show master status; +------------------+-----------+--------------+------------------+-------------------+ | File | Position | Binlog_Do_DB | ...
skiddaa's user avatar
  • 11
0 votes
1 answer

Percona pt-table-checksum output is in infinite loop "Waiting for the --replicate table to replicate"

We have following Multi master replication scenario. We are using Mariadb 10.1.34 and percona 3.0.11 Master: Name: db-master1 ( Slave: Name: db-slave2 ( Replica ...
Muhammad Rashid's user avatar
0 votes
1 answer

Validate data between two large tables

I have this scenario. Data files are transferred from multiple stores (transactions) to the head office as they happen. For each store the table in question is pretty big in size. At the head office, ...
JohnG's user avatar
  • 1,071
0 votes
1 answer

Redundant argument in printf at /usr/bin/pt-table-checksum

While pt-table-checksum seems to work well for most tables, a few of the big ones get this: Error checksumming table mydb.mytable: Redundant argument in printf at /usr/bin/pt-table-checksum line ...
Collector's user avatar
  • 135
0 votes
2 answers

how to make sure pt-sync-table data is the latest?

the first step is to checksum difference and record into percona.checksum table pt-table-checksum h=xx,P=xx,u=xx,p=xx method=dsn=h=xx,D=xx,t=xx --databases=kobe the second step is to print the ...
LawrenceLi's user avatar
3 votes
2 answers

Skipping chunk X of Y.Z because MySQL chose no index instead of the word_sid_typeindex

My environment: # cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.8 (Santiago) # uname -a Linux A.B.C 2.6.32-642.4.2.el6.x86_64 #1 SMP Mon Aug 15 02:06:41 EDT 2016 x86_64 x86_64 ...
alexus's user avatar
  • 605
2 votes
1 answer

pt-table-checksum to compare two tables? [closed]

I'm trying to find a way of comparing two tables in two databases (master and slave), as I have applied some slightly different settings to one, and need to see what affect it has (if any) on the data ...
IGGt's user avatar
  • 2,086
-1 votes
1 answer

pt-table-checksum show wrong DIFF

I'm try to use pt-table-checksum tool. I have Master/Slave tables, and I add some rows to the slave to check it. pt-table-checksum --ignore-databases mysql S=/tmp/5.6.22_3306_Master/data/mysql.sock --...
ElazarG's user avatar
0 votes
1 answer

pt-table-checksum toolkit for few databases from file

I've got a question. I'm doing a simple script right now and it isn't working like I want. #!/bin/bash cat /etc/backup.conf | egrep -v "(^#.*|^$|^--.*)" > /tmp/databases while read ...
zieloneoko's user avatar
4 votes
1 answer

pt-table-checksum says there is a difference but pt-table-sync with --print says nothing

I am using pt-table-checksum to ensure master-slave is synchronized. When I run pt-table-checksum, I see some differences on employee_profile.trigger_log but when I use pt-table-sync with --print, I ...
Luke Nguyen's user avatar
3 votes
1 answer

Accuracy of mysqldbcompare vs other tools like pt-table-checksum

I was curious to hear what everyone's experiences are with using mysqldbcompare vs pt-table-checksum( from Percona Toolkit ) to find the differences between two MySQL databases. I have heard that pt-...
user1805458's user avatar
1 vote
1 answer

pt-table-checksum - Verify MySQL replication integrity

export/import: $ mysqldump -h6dhdbm01 -p clee2 users > 6dhdbm01-clee2.users.sql Enter password: $ echo $? 0 $ mysql clee2 < 6dhdbm01-clee2.users.sql $ echo $? 0 $ pt-table-checksum: $ pt-...
alexus's user avatar
  • 605
5 votes
2 answers

pt-table-checksum and row-based replication

The set up I work with is MySQL 5.5 in a master-slave replication configuration, but we have to use "MIXED" replication (statement and row-based) because we use an application that requires it, and it ...
dmgig's user avatar
  • 281