Re: Reducing load for LAMP app?


"Gilles Ganault" <nospam@xxxxxxxxxx> wrote in message
news:iqrrn3dmfhl974du205pnfm9onp53gsbn6@xxxxxxxxxx
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.


.

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)
  • 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: Sperrt Mysqldump die DB?
    ... 5G RAM und 2G Swap in Benutzung. ... Wie teilt sich das auf MySQL ... die fett Speicher ... Wozu brauche ich so ein grosses Log? ...
    (de.comp.datenbanken.mysql)
  • 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)
Loading