On Jul 8, 2008, at 7:49 PM, Goldeneye Solutions Information wrote:
I’m been reading up on FOR UPDATE NOWAIT and it looks like It was
added in 8.1.
How difficult is it to add FOR UPDATE SKIP LOCKED or something
similar? (basically skip locked rows / oracle syntax)
More background here:
http
I'm been reading up on FOR UPDATE NOWAIT and it looks like It was added in
8.1.
How difficult is it to add FOR UPDATE SKIP LOCKED or something similar?
(basically skip locked rows / oracle syntax)
More background here:
http://forge.mysql.com/worklog/task.php?id=3597
It would be quite u
Csaba Nagy wrote:
> On Wed, 2008-07-09 at 16:23 +0800, Craig Ringer wrote:
>> Especially if it returned an updated row count or supported the
>> RETURNING clause, so you could find out after the fact what was or
>> wasn't done.
>
> Well, it is supposed to be used as "SELECT ... FOR UPDATE SKIP LOC
On Wed, 2008-07-09 at 16:23 +0800, Craig Ringer wrote:
> Especially if it returned an updated row count or supported the
> RETURNING clause, so you could find out after the fact what was or
> wasn't done.
Well, it is supposed to be used as "SELECT ... FOR UPDATE SKIP LOCKED",
so you can in fact pu
Csaba Nagy wrote:
> On Wed, 2008-07-09 at 00:48 -0400, Tom Lane wrote:
>> "Jonathan Bond-Caron" <[EMAIL PROTECTED]> writes:
>>> It would be quite useful to implement a database queue. Although FOR UPDATE
>>> NOWAIT and trying again can work as well as other techniques,
>>> just skipping over the l
On Wed, 2008-07-09 at 00:48 -0400, Tom Lane wrote:
> "Jonathan Bond-Caron" <[EMAIL PROTECTED]> writes:
> > It would be quite useful to implement a database queue. Although FOR UPDATE
> > NOWAIT and trying again can work as well as other techniques,
>
> > just skipping over the locks has its advan
"Jonathan Bond-Caron" <[EMAIL PROTECTED]> writes:
> It would be quite useful to implement a database queue. Although FOR UPDATE
> NOWAIT and trying again can work as well as other techniques,
> just skipping over the locks has its advantages (simplicity and zero wait)
And disadvantages, such as
I'm been reading up on FOR UPDATE NOWAIT and it looks like it was added in
8.1.
How difficult is it to add FOR UPDATE SKIP LOCKED or something similar?
(basically skip locked rows / oracle syntax)
More background here:
http://forge.mysql.com/worklog/task.php?id=3597
It would be quite u
