MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Seeking Code to Reproduce InnoDB's Interleaved Lock Mode with Statement-Based Replication
Posted by: Plateau Plateau
Date: November 30, 2023 12:55AM

Hello, may I ask if you can provide the code to reproduce the statement "In this lock mode, no “INSERT-like” statements use the table-level AUTO-INC lock, and multiple statements can execute at the same time. This is the fastest and most scalable lock mode, but it is not safe when using statement-based replication or recovery scenarios when SQL statements are replayed from the binary log."?

https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html#innodb-auto-increment-lock-modes

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


Subject
Written By
Posted
Seeking Code to Reproduce InnoDB's Interleaved Lock Mode with Statement-Based Replication
Plateau Plateau
November 30, 2023 12:55AM


Sorry, only registered users may post in this forum.
Click here to login

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.