seniorMySQL
Inter-Transaction Visibility in REPEATABLE READ
Updated May 4, 2026
Short answer
How InnoDB ensures consistent snapshots.
Deep explanation
Uses the 'Transaction ID' (TRX_ID) in the row header. If a row's TRX_ID is greater than the snapshot's max ID, the version from the Undo Log is used.
Unlock with a Pro subscription to view this section.
View pricingReal-world example
No real-world example available yet.
Unlock with a Pro subscription to view this section.
Upgrade to ProCommon mistakes
No common mistakes listed yet.
Unlock with a Pro subscription to view this section.
Upgrade to ProFollow-up questions
No follow-up questions available yet.
Unlock with a Pro subscription to view this section.
Upgrade to Pro