build1 publisher
A FOR UPDATE clause moves a SELECT onto InnoDB's write path
InnoDB applies MVCC to reads and pure locking to writes, so under the default Repeatable Read the same predicate can be answered from a snapshot frozen at your first statement or from the newest committed row.
Publishers:dev.to
Reality
- Evidence52
- Adoption
- Insufficient
- Hype gap+8
- Incentives25
- Confidence45