Hi,
Is not the same case....Jeff didn't said anything about TRANSACTIONS.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Gelu Gogancea" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Jeff Snoxell" <[EMAIL PROTECTED]>
Sent: Thursday, December 12, 2002 8:44 PM
Subject: Re: More locking issues
> Gelu Gogancea wrote:
>
> >If you have more than one user connected to the database which handled
the
> >same tables, you need to use LOCK/UNLOCK tables.
> >MySQL daemon don't lock tables or records if you don't require this.
> >
> >
>
> Can I ask if this is in fact accurate? As I understand it, MySQL does a
> fairly good job of locking the tables, that's part of the performance
> problem of MyISAM vs. InnoDB table types with many updates running. And
> with InnoDB, you get a Repeatable Read isolation level by default which
> 'feels like' getting a read lock.
>
> What did you mean that it doesn't lock tables? SQL
>
> --
> Michael T. Babcock
> C.T.O., FibreSpeed Ltd.
> http://www.fibrespeed.net/~mbabcock
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
