MySQL Forums
Forum List  »  InnoDB

auto_increment and binary logging
Posted by: Mohil Chandra
Date: November 11, 2008 08:46AM

Hi,
I've gone through the document on auto increment handling in innodb. What I understood is that mysql uses a table-level auto-inc lock to provide consistency among records in master and slave when replication is enabled.

So, is this handling strategy(table level locking) is used even when the binary logging is not enabled??

Also, if the above is true, then the process will screw up only if there are too many simultaneous inserts ,and it will not depend on whether binary logging or replication is enabled or not??

Lets say if there are too many inserts, then will the selects on the table be affected??

Please clarify.

Options: ReplyQuote


Subject
Views
Written By
Posted
auto_increment and binary logging
2827
November 11, 2008 08:46AM
1725
December 19, 2008 12:43AM


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.