Under the mysql8.0 rr level,
Open two Windows,
Session1 perform the begin; Insert into t values (70,70,70);

Session2 an insert into t values (80,80,80);

Performs the select * from t in session1; The results showed that the query to insert session2,

Session2 perform insert into t values (90,90,90);
Session1 to execute the select * from t; Found the query is less than the second insert session2,
Please explain

CodePudding user response:

You this is not the data proved that the RR next to select for the first time to start the snapshot

If you want to transaction built can be used to start the transaction from the start with consistent snapshot