Peter, The first example is READ COMMITTED. I’ve changed the isolation level to get that example of a phantom read. With REPEATABLE READ the rows and gaps gets locked and then you get the lock wait timeout.
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…). The reads are not excactly sequential, there is a small gap between each. it is difficult to figure our what the… Heikki – it should be possible to implement online reorganize which locks and reorganizes small portions of table online. Q38: Seems that…
