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.
On Fri 2002-12-06 at 10:28:23 -0600, [EMAIL PROTECTED] 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 specifically designed to prevent
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
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
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
duplicates.
My current process:
select * from run where job_id = 111 and