List:General Discussion« Previous MessageNext Message »
From:Waynn Lue Date:July 1 2008 12:00am
Subject:Re: Queues on MySQL?
View as plain text  
Thanks for the suggestion--is that essentially using
http://www.php.net/posix_mkfifo within PHP?

On Mon, Jun 30, 2008 at 7:11 AM, Jerry Schwartz
<jschwartz@stripped> wrote:
>>-----Original Message-----
>>From: Waynn Lue [mailto:waynnlue@stripped]
>>Sent: Monday, June 30, 2008 6:04 AM
>>To: MySQL List
>>Subject: Queues on MySQL?
>>
>>Hey,
>>
>>I'm looking to write a queue backed by MySQL to enable batch updates
>>of a system I'm writing.  Essentially what I wanted to do was every
>>time I want to enqueue, I just INSERT a new row into a table.  Then I
> [JS] Just a bit of a warning: in my (very old) experience, this is not the
> most effective way of implementing a queue. Does your environment support
> fifo files, or can you emulate them? They have a lot less overhead.
>
>>have a cron job that runs every X minutes, selects all the existing
>>rows and does the actions, then deletes the rows that have been
>>selected.  It's a fairly simple algorithm, and not hard to implement,
>>but I'm wondering if there are existing tools out there that do queues
>>that will have additional functionality in case I ever want to change
>>it.
>>
>>A quick Google search turned up links like http://q4m.31tools.com/,
>>but I'm not sure what's a good one.
>>
>>Thanks,
>>Waynn
>>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>>infoshop.com
>
>
>
>
>
Thread
Queues on MySQL?Waynn Lue30 Jun
  • RE: Queues on MySQL?Jerry Schwartz30 Jun
    • Re: Queues on MySQL?Waynn Lue1 Jul
      • RE: Queues on MySQL?Jerry Schwartz1 Jul
        • Re: Queues on MySQL?Waynn Lue1 Jul
          • RE: Queues on MySQL?Jerry Schwartz2 Jul