I once had such a hit one a apache/mysql box, and for me it served well to work on the number of connections apache keeps open. shorten keep-alive time, check if any of the scripts do unneeded connections to mysql. In my case it was a mediawiki, and by tuning it a bit I was able to keep it running on a 2x500Mhz P3 (running TSL2.0) 512MB Ram without errors. Response time will go up, at peak 10k visitors per hour (with a 1 in 30 visitors edit rate in the wiki) response time was going up to 30 sek. or more. but no lockups, no error messages. matthias ps: if it wouldn't have been a catastrophe first-aid project I would have time to document, install more ram and and and. so it was just a wiki running on a webserver filled by lots of individuals. ...
matthias ps: there are tcp settings tips on the net (apache tuning howto etc.), setup good monitoring and then start tuning ... On 24.05.2006, at 08:11, Willy wrote: > Both server are dedicated physically. So any tips for the conf file? > > Regards > > > Willy > ----- Original Message ----- > From: "Morten Nilsen" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, May 24, 2006 11:32 AM > Subject: Re: tips for high traffic web and database server > > >> Willy wrote: >>> Hi, >>> My local web (Apache) and database (MySQL) server service so many > simultanous requests, it's about 5000 - 10000 requests/minute. Any > tips how > to make it always service the requests well? Because sometimes it > fails and > locked (especially MySQL). Thanks for the tips. >> >> with that many requests, I would suggest moving the MySQL to a >> dedicated >> server.. You would then need to increase the number of simultaneous >> connections in my.cnf, and the number of child threads in apache >> >> Depending on what is being served, an alternative could be to put a >> couple proxies in front of the webserver, so not all the requests >> actually hit the webserver all the time.. >> >> -- >> Cheers, >> Morten >> :wq >> _______________________________________________ >> tsl-discuss mailing list >> [email protected] >> http://lists.trustix.org/mailman/listinfo/tsl-discuss > > _______________________________________________ > tsl-discuss mailing list > [email protected] > http://lists.trustix.org/mailman/listinfo/tsl-discuss _______________________________________________ tsl-discuss mailing list [email protected] http://lists.trustix.org/mailman/listinfo/tsl-discuss
