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

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