Does it have exclusive and shared? -James
-----Original Message----- From: Chris Nolan [mailto:[EMAIL PROTECTED] Sent: Monday, February 16, 2004 4:52 AM To: James Kelty Cc: [EMAIL PROTECTED] Subject: Re: Locking Hi! Next-key locking essentially doesn't work on rows - it works on indexes. It ensures that "phantom reads" can't happen. InnoDB does indeed do row-locking. In fact, it has one of the most efficient representations of locks of any relational database. Regards, Chris On Mon, 2004-02-16 at 23:43, James Kelty wrote: > How is 'next-key' locking correctly advertised as 'row-level' locking? I > don't actually see that InnoDB has row-level locking at all. Am I totally > wrong on that? > > > > -James > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]