MySQL Forums
Forum List  »  Replication

Re: binlog overflow
Posted by: Rick James
Date: April 25, 2013 09:33PM

> In master, there is warning like replication overflow.

It might help to have the specifics. I have never heard of such a message. A _guess_ is that you inserted a LONGTEXT or LONGBLOB that was nearly 4GB, and it would have caused the binlog to exceed 4GB; could that have happened?

> I guess the binlog writting speed doesn't match the speed of data loading. So, there is some data lost.

The binlog is written as part of the 'loading', so that is not possible.

Have you found what is missing?

pt-table-checksum

Options: ReplyQuote


Subject
Views
Written By
Posted
1535
April 24, 2013 07:55PM
Re: binlog overflow
829
April 25, 2013 09:33PM
697
April 28, 2013 02:57AM
748
April 30, 2013 10:41PM
746
May 03, 2013 02: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.