> I have a web site (Apache, PHP, MySql) with a considerable amount of
> traffic (1 Million Hits daily / 50'000 Pageimpressions daily) running
> on a Red Hat Linux/PIII-1GHz/1.5GB RAM-Server.
> When we set up the server, 100 concurrent Sessions created a load of
> about 5 and the server was quite fast. Right now the same number of
> sessions results in a load of 30. What's the reason? The table have
> grown by maybe 20%, but indexes are set correctly. The disk is quite
> full (about 90% full). Could the disc activity be the reason?
> Thanks for your answers!
Ill take a stab at this one / but Ill forwarn you that this is theory
b/c I have no sites that have that kind of traffic.
When you say Sessions.. do you mean that you are implementing some
type of user tracking / session management? If so .. is it memory
based or disk based? If the latter is the case, I'd have to say that
disk reads are much more expensive than memory reads... switch to
something that is memory based.
Maybe you are implementing sessions managed by a session table in
mysql... if so, are you cleaning it out periodically?
Above and beyond that, I'd have to say if cost were not of an issue,
take neopets as a case study and use oracle/apache/php combo. It
works for them b/c the average user on the site says ~ 20mins per
visit. That or use better session management ideas.