Questions tagged [pt-table-checksum]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
12 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 | ...
user avatar
  • 11
0 votes
0 answers
43 views

pt-table-sync perfomance/load on a production MySQL RDS instance

Hi Percona User group, I’m trying to access the performance implication of using pt-table-sync tool to replicate a collection of tables from a schema on production server (on load) to a replica schema ...
user avatar
0 votes
1 answer
478 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 ...
user avatar
0 votes
1 answer
1k 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, ...
user avatar
  • 1,051
0 votes
1 answer
752 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 ...
user avatar
  • 133
0 votes
2 answers
944 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 ...
user avatar
3 votes
2 answers
484 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 ...
user avatar
  • 575
2 votes
1 answer
1k 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 ...
user avatar
  • 1,920
-1 votes
1 answer
359 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 --...
user avatar
0 votes
1 answer
52 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 ...
user avatar
4 votes
1 answer
625 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 ...
user avatar
3 votes
1 answer
923 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-...
user avatar
1 vote
1 answer
698 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-...
user avatar
  • 575
5 votes
2 answers
3k 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 ...
user avatar
  • 281