mysql load, help with ideas related to local cache

justin justin at
Tue Feb 24 17:11:17 MST 2009

On Tue, Feb 24, 2009 at 5:51 PM, Matt Nelson <matt at> wrote:
> I have a web page that runs under PHP.  I query a mysql database every 5-10
> seconds, with each meta refresh.  This was fine and worked decent, until
> other people started using it.  Now the connections have grown to a number
> that they need to be handled better.  I was thinking of creating a daemon
> that runs every 5 seconds and then populates a flat file that apache/php
> would read with every refresh thus limiting the load to one connection every
> 5 seconds.

You could always switch to push :)


More information about the PLUG mailing list