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]