Questions tagged [pt-table-checksum]
The pt-table-checksum tag has no usage guidance.
13
questions
1
vote
0
answers
17
views
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 | ...
- 11
0
votes
1
answer
681
views
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 (192.168.14.5)
Slave: Name: db-slave2 (192.168.15.5) Replica ...
0
votes
1
answer
2k
views
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, ...
- 1,071
0
votes
1
answer
861
views
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 ...
- 135
0
votes
2
answers
1k
views
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 ...
- 321
3
votes
2
answers
640
views
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 ...
- 605
2
votes
1
answer
2k
views
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 ...
- 2,086
-1
votes
1
answer
441
views
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 --...
- 1
0
votes
1
answer
56
views
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 ...
4
votes
1
answer
790
views
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 ...
- 729
3
votes
1
answer
967
views
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-...
- 281
1
vote
1
answer
798
views
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-...
- 605
5
votes
2
answers
4k
views
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 ...
- 281