Re: insert/delete locking with innodb

2001-11-21 Thread Heikki Tuuri
Hi! >If I have a process inserting into an innodb table in 200 insert chunks. >i.e. it commits after every 200 inserts, must another process, which wants >to delete data from this table, wait for the next commit on the insert end? >If not is there any reason why my process is doing this. Do you

insert/delete locking with innodb

2001-11-20 Thread Richard Clarke
If I have a process inserting into an innodb table in 200 insert chunks. i.e. it commits after every 200 inserts, must another process, which wants to delete data from this table, wait for the next commit on the insert end? If not is there any reason why my process is doing this. Ric --