MySQL Forums
Forum List  »  InnoDB

Doc on InnoDB AUTO_INCREMENT handling
Posted by: Steven Wong
Date: September 19, 2008 03:47PM

http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.html says:

(1) 'Therefore, if you are using statement-based replication, you must either avoid INSERT ... ON DUPLICATE KEY UPDATE or use innodb_autoinc_lock_mode = 0 (“traditional” lock mode).'

But it also says:

(2) 'This mode [“consecutive” lock mode = 1] is safe for use with statement-based replication.'

(3) 'If you are using statement-based replication, you should set innodb_autoinc_lock_mode to 0 or 1'

It seems that (1) conflicts with (2) and (3). Either that or I misunderstand something. Would someone please clarify?

Options: ReplyQuote


Subject
Views
Written By
Posted
Doc on InnoDB AUTO_INCREMENT handling
3135
September 19, 2008 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.