MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Is mixed based binlog OK for setting 'innodb_autoinc_lock_mode=2'?
Posted by: feng guo
Date: May 26, 2014 07:17AM

Rick James Wrote:
-------------------------------------------------------
> innodb_autoinc_lock_mode is for some rather
> esoteric situations in Replication and/or
> depending on what auto_inc value are generated.
> Usually, innodb_autoinc_lock_mode is not worth
> changing.
> What is your use case?

When buik inserting,default innodb_autoinc_lock_mode=1 will have a table lock,while
innodb_autoinc_lock_mode=2 will have a better performance~
So,if innodb_autoinc_lock_mode=2 work well with mixed binary?

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.