mysql load, help with ideas related to local cache

Matthew Frederico mfrederico at gmail.com
Tue Feb 24 17:24:11 MST 2009


I second memcached.

On Tue, Feb 24, 2009 at 3:58 PM, Barry Roberts <blr at robertsr.us> wrote:
> On 02/24/2009 03:51 PM, Matt Nelson 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.
>>
>> Does anybody have any better ideas?
>>
>>
>
> http://www.danga.com/memcached/
>
> maybe?
>
> /*
> PLUG: http://plug.org, #utah on irc.freenode.net
> Unsubscribe: http://plug.org/mailman/options/plug
> Don't fear the penguin.
> */
>



-- 
-- 
-- Matthew Frederico



More information about the PLUG mailing list