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.