Transaction isolation levels are essential for maintaining data integrity and managing concurrency in database systems. Two of the highest isolation levels are Serializable and Repeatable Read, each ...
-- RECORD: S,REC_NOT_GAP on id=30 ← 共有レコードロック -- RECORD: S,GAP on id=30 ← 共有ギャップロック (20,30) -- RECORD: S,GAP on id=40 ← ...