Ran into an issue where shared locks were being applied (for InnoDB) on a statement with this format: insert into a select * from b; While that statement is running, not only does a have some locks applied, but so does b! problem is… my statement was not exactly that simple. Instead, the select statement [...]
