We have a simple master->slave set up. Trying to use pt-table-sync to bring slave in sync with master. Can’t use the replication method because we are so far out of sync.
Problem is, the SELECT statements on the master block/lock other INSERT queries coming in from our app.
Is there a way to make pt-t-s wait a second after each Nibble SELECT so that other queries have time to run?
Tried using --buffer-in-mysql, --lock 0, --lock 1, --transaction to no help.
All tables InnoDB.