Monthly Archives: March 2007
Avoiding Insert Locking With Insert Into
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 … Continue reading
Filed under SQL