Posted by faulkes on 01/04/08 15:15

On Jan 4, 3:34 am, Gilles Ganault <nos...@nospam.com> wrote:
> 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.

I will agree with the statement made in the post that 'before you can
optimize, you need to know where you are optimizing'.

1. Eaccel (or any pre-compiler) will certainly help if the bottleneck
is PHP (to a point.)
2. Use the XDebug package & Kcachegrind (or wincachegrind) to look at
what the code is doing and if it can be optimized.
3. Depending on site needs, considering caching options such as
memcached.

Read the IBM series of articles on tuning/performance for LAMP

http://www.ibm.com/developerworks/linux/library/l-tune-lamp-1/#resources

faulkes

[Back to original message]