MySQL Forums
Forum List  »  Replication

Statement/row questions
Posted by: Alon Lubin
Date: February 11, 2009 05:12AM

Hi,
We have a master database version 5.1.24
Our slaves are 5.1.31

The replication runs in mixed mode.

When we run delete command on the master (deleting 20,000+ rows), it is translated into rows deletion on the slaves which cause replication lag.

The original delete takes few seconds on the master.

Any idea why this happens?
Why this does not works as statement replication?

Thanks, Alon.

Options: ReplyQuote


Subject
Views
Written By
Posted
Statement/row questions
2749
February 11, 2009 05:12AM
1723
February 11, 2009 05:17AM
1814
February 11, 2009 06:15AM
1783
February 12, 2009 10:13AM
1859
February 13, 2009 11:26PM
1786
February 18, 2009 04:07AM
1703
February 19, 2009 12:34AM
1671
February 19, 2009 11:21AM
1704
February 20, 2009 12:49AM


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.