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
-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 Towey
-Original Message-
From: Allen
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 worker = null
2) Producer sleeps and loops back to step #1
Worker(s):
On Mon, Sep 7, 2009 at 8:18 PM, Allen Fowlerallen.fow...@yahoo.com 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
On Mon, Sep 7, 2009 at 8:18 PM, Allen Fowlerallen.fow...@yahoo.com 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
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