List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:September 6 2001 11:44pm
Subject:Re: Delete blocking other requests
View as plain text  
At 1:39 PM -0700 9/6/01, Stuart Scamman wrote:
>Delete from table where var = ... blocks other sql requests such as
>select and insert on a multi-million record database until it is done.
>For example, to delete 11,000 records out of 13 million takes 2 min 30
>seconds.  All other connections are blocked until done.  Is there a way
>around this ?  Thanks ahead of time.

DELETE puts a write lock on the table, which blocks other readers and
writers.

-- 
Paul DuBois, paul@stripped
Thread
Delete blocking other requestsStuart Scamman6 Sep
  • Re: Delete blocking other requestsPaul DuBois7 Sep