Re: Innodb row locking question

2002-12-08 Thread Heikki Tuuri
Mike, - Original Message - From: "Mike Gohlke" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, December 07, 2002 6:44 PM Subject: Re: Innodb row locking question > > > Benjamin Pflugmann wrote: > > >Hello. > > > &

Re: Innodb row locking question

2002-12-07 Thread Benjamin Pflugmann
Hello. On Sat 2002-12-07 at 10:36:00 -0600, [EMAIL PROTECTED] wrote: [...] > >Why do you repeat "job_id = 111 and thread_id = 0"? If you are using a > >transaction seperation level of at least REPEATABLE READ (which is the > >default), InnoDb assures that you always see the same rows within one >

Re: Innodb row locking question

2002-12-07 Thread Mike Gohlke
Benjamin Pflugmann wrote: Hello. On Fri 2002-12-06 at 10:28:23 -0600, [EMAIL PROTECTED] wrote: Heikki and all, I've got a quick question which may be more general sql related but since I'm using innodb tables specifically for the row locking. The following process description is specifical

Re: Innodb row locking question

2002-12-07 Thread Benjamin Pflugmann
Hello. On Fri 2002-12-06 at 10:28:23 -0600, [EMAIL PROTECTED] wrote: > Heikki and all, > I've got a quick question which may be more general sql related but > since I'm using innodb tables specifically for the row locking. > > The following process description is specifically designed to prevent