[CentOS] Centos/Linux Disk Caching, might be OT in some ways

On Jan 25, 2010, at 7:02 PM, JohnS <jses27 at gmail.com> wrote:

>
> On Mon, 2010-01-25 at 18:51 -0500, Ross Walker wrote:
>
>>> Instead look at the way your PHP Code is
>>> Encoding the BLOB Data and if your really need the speed since now
>>> it's
>>> MySQL DB, make you own custom C API for mysql to encode the BLOB.   
>>> The
>>> DB can do this like that much faster then your PHP app ever thought
>>> of.
>>
>> I believe the OP said he was running postgresql.
>>
>
> Quoted from OPs previous mail hes not sure lol....
>
> """The web application is written in PHP and runs off MySQL and/or
> Postgresql."""

Ah, well #1 on his list then is to figure out what he is running!

If there are BLOB/TEXT fields those should really be queried  
separately and put in some cache shared by the PHP app (or discarded  
depending on how frequently used). Not knowing what they are, probably  
avatars, which should be cached, as opposed to uploads or such which  
shouldn't. Who knows without more info.

-Ross