So where's the row locking? I configure my database with Innodb + READ COMMITED, by this configuration by using autocommit=1, delete should be done on data commited to disk. Other thread should be able to insert/update.
CMIIW > Tables are locked on delete because, like an update, they are changing > data. > > Imagine issuing a REPLACE statement after a DELETE statement. If the > DELETE locks the table, then the REPLACE happens AFTER the DELETE, as > you wanted. If the DELETE does not lock the table, then it's possible > the REPLACE will happen before the DELETE, and the DELETE will delete > the row you just replaced. > > -Sheeri > > On 2/9/06, Ady Wicaksono <[EMAIL PROTECTED]> wrote: >> Why table locked on delete? >> > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]