MySQL Forums
Forum List  »  Replication

Re: Query not replicating all records
Posted by: Rick James
Date: February 24, 2014 04:41PM

What version are you running on each machine? Perhaps this is worthy of a bug at bugs.mysql.com, but it would need a reproducible test case.

Were the tables identical before starting the query? (pt-table-checksum)

Suggest you use a LEFT JOIN instead of NOT EXISTS.

Options: ReplyQuote


Subject
Views
Written By
Posted
1734
February 19, 2014 09:03AM
767
February 19, 2014 09:04AM
Re: Query not replicating all records
830
February 24, 2014 04:41PM
783
February 25, 2014 11:36AM
674
February 27, 2014 12:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.