|
Posted by Richard on 01/05/08 01:58
"Richard" <root@localhost> wrote in message
news:477ee389$0$91156$dbd43001@news.euronet.nl...
>
> "Gilles Ganault" <nospam@nospam.com> wrote in message
> news:iqrrn3dmfhl974du205pnfm9onp53gsbn6@4ax.com...
>> Hello,
>>
>> I'm no LAMP expert, and a friend of mine is running a site which is
>> a
>> bit overloaded. Before upgrading, he'd like to make sure there's no
>> easy way to improve efficiency.
>>
>> A couple of things:
>> - MySQL : as much as possible, he keeps query results in RAM, but
>> apparently, each is session-specific, which means that results
>> can't
>> be shared with other users.
>> Is there something that can be done in that area, ie. keep the
>> maximum
>> amount of MySQL data in RAM, to avoid users (both logged-on and
>> guests) hitting the single MySQL server again and again?
>>
>> - His hoster says that Apache server is under significant load. At
>> this point, I don't have more details, but generally speaking, what
>> are the well-know ways to optimize PHP apps?
>>
>> Thank you.
>
> Why (or how) are the queries "session-specific"?
> No way to get rid of that?
>
> Richard.
>
Oh and BTW:
>> - MySQL : as much as possible, he keeps query results in RAM
It seems like a waste of memory to keep the results in RAM when you
know they will not be of any use to you afterwards. Immediately free
the mem for the next results sounds better to me.
Richard.
Navigation:
[Reply to this message]
|