Load problems... Too many hits for that Machine?
Any advise on this issue is very much appreciated!
We're having some problems here, with one of our Dedicated's.
After the relaunch of the site, changing from mostly static HTML Sites to completely PHP, we got a Big Load problem.
Machine started to spike up into the hundreds. After tweaking apache and Mysql we'r down to 2.somethings in the peak periods, and down to ~0,5 in the less frequented times (at night)
The Site has 30-50k hits per Day. (though pushing not more than 3mbit at peak times)
While the Server Hardware looks like this:
P3 1GHz, 512MB Ram, 80GB IDE HDD
I think the RAM is the problem, as it's always filled up, but what i don't get is, that the Swap space isn't beeing used (just 10mb of 1GB)
As i was tweaking Mysql, i found that
an output from show status
| Handler_read_rnd | 25805262 |
brought back this ...
I was browsing throught the man's at mysql.com where i found this:
If Handler_read_rnd is big, then you probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
1) Is it the hardware which hasn't got enough power? (CPU is always 50% or more idle, so that seems to be alright)
2) Is the PHP code badly coded?
3) Or did i just tweaked sth. wrong?
Any experiences here with sth. like that, or such a configuration?
Thanks for your help!
best regards,
