I'm running this new VPS server centos with apache and mySQL, on busy days proberly doing 40.000 pageviews and ech time we peak boom server killed. Now Ive studyed varius tweaks but its really hard to tell, coz whatever i apply in httpd.conf or my.cnt it just dies on me each time hit the peaks. What even more amazed me is that ive got like 500 mb left of the 1gb server i have where everything pop3, smpt, virus check have been shutdown for free the server some memory. I would very much like to hear someone with only 1gb server, how them http.conf and my.cnt looks like for a rather busy at times site. The prob is really when i wanna tweak it all i see outthere is tweaks for busy sites, lotta memory or tweak for free memory less busy sites would love a few hint when server dies about 500mb free ressources and cpu like max 0.30 the supooert just keeps say buy a bigger server lol, easy for them to say, but the site used to run fine on a 5buck a month server so i dont really see how a bigger would help since it have been running fine on shared for a year until we got so much traffic the shared one could not cope no more Thanks
You should have a look at exactly what are causing these spikes. Check the logs, for any errors. Also with 40 000 page view, i would recommend either a solid vps, or a cheap dedicated server!
You will require to checkout the logs for apache/mysql and see the reason. After which you can determine which particular software needs to be tweaked. It seems you will require to tweak the apache limits
Your problems will be solved when you configure your Apache's MPM settings. 40k/day site can easily be handled on a VPS with half those resources. Turn KeepAlives to 2 seconds. Configure your MaxClients and ServerLimit settings.