I am running MySQL 5.7 in aurora. The intent is to avoid gap locks during a select which is used to create a temporary table for later use. It causes lock timeout with other sessions trying to delete different key values that fall within scanned rows by the first select creating gap lock. I see sev…

transaction isolation read uncommitted still causes S-lock on RW-latch during select

Venkat October 6, 2020, 11:21am 6

Also, yes. I see your point on latch. I was surprised with the timeout by another session that was attempting to delete from the same table but a different key.

Topic		Replies	Views
Question about innodb's lock mode Other MySQL® Questions	2	964	May 31, 2010
InnoDB lock wait timeout Other MySQL® Questions	2	1969	April 28, 2008
Deadlock with innodb SELECT..INSERT Other MySQL® Questions	1	372	December 25, 2009
SELECT FOR UPDATE vs. UPDATE, then SELECT Other MySQL® Questions	0	1482	February 7, 2011
select from table while inserting data Other MySQL® Questions	0	540	May 10, 2015

transaction isolation read uncommitted still causes S-lock on RW-latch during select

Related topics