>-Original Message-
>From: Gavin Towey [mailto:gto...@ffn.com]
>Sent: Tuesday, September 08, 2009 1:41 PM
>To: Allen Fowler; mysql@lists.mysql.com
>Subject: RE: Queue / FIFO in MySQL?
>
>You can add a LIMIT n to your update clause.
>
>Regards,
>Gavin
You can add a LIMIT n to your update clause.
Regards,
Gavin Towey
-Original Message-
From: Allen Fowler [mailto:allen.fow...@yahoo.com]
Sent: Monday, September 07, 2009 5:18 PM
To: mysql@lists.mysql.com
Subject: Queue / FIFO in MySQL?
Hello,
I need to create a system where records are g
Please check out http://q4m.31tools.com/*. *It is a message queue storage
engine with sql interface. Havent used it in a production setup though we
did some tests.
--
Thanks
Alex
http://alexlurthu.wordpress.com
On Mon, Sep 7, 2009 at 8:18 PM, Allen Fowler wrote:
> Note: In this scheme the worker winds up with all "new" records generated
> since the last worker claimed any. Not sure how else to guarantee atomicity.
> I would prefer "only n records per request". Ideas?
SELECT...FOR UPDATE followed by one
On Mon, Sep 7, 2009 at 8:18 PM, Allen Fowler wrote:
> Hello,
>
> I need to create a system where records are generated by a "producer" process
> and processed by several "worker" processes.
>
> I was thinking about something like:
>
> Producer:
> 1) Producer INSERTs new records with "state" = "new