Aikesheng Open Source Community

Jun 23, 2020 · Databases

Understanding Half-Consistent Reads in InnoDB and Their Impact on Transactions

This article explains the concept of half‑consistent reads in MySQL InnoDB, describes the conditions under which they occur, presents two test cases with detailed lock‑waiting behavior, analyzes why certain sessions are blocked or not, and summarizes the optimization benefits for RC isolation level.