8 messages in com.mysql.lists.mysql[mysql]Concurrency with inserts
FromSent OnAttachments
Henda Carvalho27 Sep 2006 14:48 
Henda Carvalho27 Sep 2006 14:49 
Dan Nelson27 Sep 2006 15:15 
Henda Carvalho27 Sep 2006 15:31 
Dan Nelson27 Sep 2006 15:36 
Henda Carvalho27 Sep 2006 15:59 
Dan Nelson27 Sep 2006 19:44 
Jerry Schwartz28 Sep 2006 06:27 
Subject:[mysql]Concurrency with inserts
From:Henda Carvalho (hend@gmail.com)
Date:09/27/2006 03:31:35 PM
List:com.mysql.lists.mysql

Hi there,

The links that you gave me doesn't say what is suposed to happen if 2 different users are trying to make an insert (using the insert statement) to the same table.

Will the transaction abort for one of the users?

Best regards, Henda

On 9/27/06, Dan Nelson <dnel@allantgroup.com> wrote:

In the last episode (Sep 27), Henda Carvalho said:

Can somebody please tell me what is the behaviour of mysql when 2 different users are trying to make an insert to the same table.

http://dev.mysql.com/doc/refman/5.0/en/table-locking.html http://dev.mysql.com/doc/refman/5.0/en/concurrent-inserts.html

-- Dan Nelson dnel@allantgroup.com