Skip to main content

Consistent Reads & Read Views

Learn Consistent Reads & Read Views (MVCC, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A consistent (non-locking) read is a plain SELECT that returns data as of a point in time, using a read view : an internal snapshot listing which transactions were active when it was created. Rows changed by transactions not visible to that view are reconstructed from undo.

More lessons in MVCC