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

Leave a Comment

Filed under SQL