MySQL Forums
Forum List  »  Replication

Re: Replication Slave update question
Posted by: Rick James
Date: August 31, 2012 06:53PM

> Did you have opened transaction?
He did -- implicitly, by having AUTOCOMMIT=OFF

I have a strong dislike for AUTOCOMMIT=OFF.

There are effectively 3 modes:

* AUTOCOMMIT=ON and don't issue COMMIT -- each statement self-commits. This makes sense in simple, non-transactional applications.
* Ignore AUTOCOMMIT and use BEGIN (or START) ... COMMIT to bracket every transaction. This is when you are serious about ACID.
* AUTOCOMMIT=OFF, plus try to remember to do COMMIT. There is always an 'open' transaction. I don't know the use for this mode.

Options: ReplyQuote


Subject
Views
Written By
Posted
2803
August 30, 2012 12:56PM
1085
August 31, 2012 04:43AM
1115
August 31, 2012 10:20AM
Re: Replication Slave update question
1158
August 31, 2012 06:53PM


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.