MySQL Forums
Forum List  »  Replication

Re: Unsafe statement advice
Posted by: Rick James
Date: July 23, 2014 08:58AM

> it would be a lot slower in row mode than statement.

It is slower because a lot more information flows through the binlog and relay log. However, with a high speed network, this slowdown may not be noticeable.

> I could also turn warnings off, but then I might miss something important.

I think the warning is suggesting that a different set of rows might be deleted; this could lead to inconsistent data and other rude surprises.

Most binlog warnings are the result of someone finally, after many years, running into some obscure end case that caused data inconsistency.

I suggest going with MIXED; a thousand DELETEs in the binlog does not sound "a lot slower". (A million rows would be a different case. Sorry, I don't have a reformulation of the DELETE off hand.)

Options: ReplyQuote


Subject
Views
Written By
Posted
2071
July 22, 2014 07:11AM
Re: Unsafe statement advice
837
July 23, 2014 08:58AM
767
July 24, 2014 07:04AM


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.