Reducing load for LAMP app?



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.
.



Relevant Pages

  • Re: Reducing load for LAMP app?
    ... MySQL: as much as possible, he keeps query results in RAM, but ... amount of MySQL data in RAM, to avoid users (both logged-on and ... guests) hitting the single MySQL server again and again? ...
    (comp.lang.php)
  • Re: Reducing load for LAMP app?
    ... MySQL: as much as possible, he keeps query results in RAM, but ... amount of MySQL data in RAM, to avoid users (both logged-on and ... guests) hitting the single MySQL server again and again? ...
    (comp.lang.php)
  • Re: Reducing load for LAMP app?
    ... I'm no LAMP expert, and a friend of mine is running a site which is a ... MySQL: as much as possible, he keeps query results in RAM, but ... amount of MySQL data in RAM, to avoid users (both logged-on and ...
    (comp.lang.php)
  • Re: Reducing load for LAMP app?
    ... MySQL: as much as possible, he keeps query results in RAM, but ... - His hoster says that Apache server is under significant load. ... are the well-know ways to optimize PHP apps? ...
    (comp.lang.php)
  • Re: For this hardware amd64, ia64 or i386 to install?
    ... 2x6MB cache WITH 16 GB RAM. ... FreeBSD 7 Production Release ... MySQL runs faster when compiled for ... Handelsregister: Registergericht Muenchen, HRA 74606, Geschäftsfuehrung: ...
    (freebsd-questions)