Re: Concurrent INSERT/DELETE

[Jean-Philippe Signorino]

Thanks for the response.

There is no other row in the table, the table is empty before the scenario.

I play only 1 request in each transaction.

The insert request takes some milliseconds but I keep the transaction opened (no commit).
(In my application, there are a lot of insert in one transaction and I want to be able to delete other rows in parallel.)

I use manual commit management (begin .... commit)


Note : I test this scenario on PostgreSQL. As expected, the second transaction is not locked. It seems to be a huge limitation of MySQL which is not able to manage concurrent insert / delete in(...) ?



Edited 2 time(s). Last edit at 04/29/2013 09:04AM by Jean-Philippe Signorino.