MySQL Forums
Forum List  »  Replication

Re: [Replication] Big Joins do not get replicated
Posted by: James Day
Date: April 24, 2005 04:32PM

You could try doing the INSERT ... SELECT in several pieces. Perhaps using WHERE primary key <10000 then WHERE primary_key >= 10000 and primary_key < 20000 and so on. That can increase reliability if the table you're selecting from is ofen locked, because it will decrease the chance of a ock wait timeout if other operations are using the table. Changing MAX_JOIN_SIZE may be the most convenient solution, though.

Options: ReplyQuote

Written By
Re: [Replication] Big Joins do not get replicated
April 24, 2005 04:32PM

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.