MySQL Forums :: Replication :: Slave Replication Error

Advanced Search

Re: Slave Replication Error
Posted by: Partha Dutta ()
Date: May 05, 2005 03:47PM

There is another mechanism that you can use, which is the skip counter. You can skip the current transaction that the replication thread is hung on and continue. You can issue the following command in mysql to skip a transaction:


Use the value 1 for any SQL statement that does not use AUTO_INCREMENT or LAST_INSERT_ID(), otherwise you will need to use the value 2. Statements that use AUTO_INCREMENT or LAST_INSERT_ID() take up 2 events in the binary log.

Partha Dutta
Senior Consultant, MySQL Inc.

Options: ReplyQuote

Subject Views Written By Posted
Slave Replication Error 13317 Tyler Ingram 05/04/2005 07:47AM
Re: Slave Replication Error 10396 Tyler Ingram 05/04/2005 08:35AM
Re: Slave Replication Error 94959 Partha Dutta 05/05/2005 03:47PM

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.