RE: [mysql]Concurrency with inserts

2006-09-28 Thread Jerry Schwartz
> Sent: Wednesday, September 27, 2006 10:45 PM > To: Henda Carvalho > Cc: mysql@lists.mysql.com > Subject: Re: [mysql]Concurrency with inserts > > In the last episode (Sep 28), Henda Carvalho said: > > One more question, > > > > What kind of tables does mysql create by

Re: [mysql]Concurrency with inserts

2006-09-27 Thread Dan Nelson
In the last episode (Sep 28), Henda Carvalho said: > One more question, > > What kind of tables does mysql create by default? innodb or myisam? The default is myisam. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: [mysql]Concurrency with inserts

2006-09-27 Thread Henda Carvalho
One more question, What kind of tables does mysql create by default? innodb or myisam? Best regards Henda On 9/27/06, Dan Nelson <[EMAIL PROTECTED]> wrote: In the last episode (Sep 27), Henda Carvalho said: > The links that you gave me doesn't say what is suposed to happen if 2 > different us

Re: [mysql]Concurrency with inserts

2006-09-27 Thread Dan Nelson
In the last episode (Sep 27), Henda Carvalho said: > 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? No; they will both proce

[mysql]Concurrency with inserts

2006-09-27 Thread Henda Carvalho
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 <[EMAIL PROTECTED]> wrote:

Re: [mysql]Concurrency with inserts

2006-09-27 Thread Dan Nelson
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-inser

[mysql]Concurrency with inserts

2006-09-27 Thread Henda Carvalho
Hello, 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. Best regards, Henda Mendes de Carvalho

[mysql]Concurrency with inserts

2006-09-27 Thread Henda Carvalho
Hello, 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. Best regards, Henda Mendes de Carvalho