Ubuntu: apache2 + mysql REAAALLLY SLOW even SSH access

Tarikc · 11-23-2012, 06:14 AM

Hello unSpawn,

After some more research on the net regarding tuning, example this link.

And more tests on the server increasing and decreasing limits and monitoring the usage and processes.

I think if I need to have it improved more I will have to increase the RAM, coz the website is "sometimes" have huge traffic passing on it, its a news based website.

Quote:

Originally Posted by unSpawn

best look at the 3xx messages in access_log.

I have looked at it and found out that it is 304 Not Modified, so nothing to be worried about?

Quote:

Originally Posted by unSpawn

Lower timeouts seems a good thing and I let the link I gave you before argue against increasing MaxClients.

I have followed the link, and based on the RAM I have I have set the MaxClients to 40, coz the max apache2 process takes 70MB of RAM each… is it normal??

As the apachetop:

Quote:

last hit: 12:13:40 atop runtime: 0 days, 21:50:22 12:13:42
All: 507713 reqs ( 6.5/sec) 4916.3M ( 64.0K/sec) 10153.7B/req
2xx: 369800 (72.8%) 3xx: 113574 (22.4%) 4xx: 11330 ( 2.2%) 5xx: 13009 ( 2.6%)
R ( 30s): 81 reqs ( 2.7/sec) 795.3K ( 26.5K/sec) 10053.9B/req
2xx: 54 (66.7%) 3xx: 22 (27.2%) 4xx: 5 ( 6.2%) 5xx: 0 ( 0.0%)

You think I'm on the right track or I got away to a totally different direction?

Thank you again for your valuable support.

unSpawn · 11-23-2012, 06:52 AM

304's are not a problem but I would still wonder what's requesting it then if it takes up over 20 per cent of the 3xx requests. 70MB RAM per child seems a lot but you should compare that number with what other sites have. Your numbers look OK at first glance but the downside of tuning is serving requests dropped to half of what it was first. If that tuning brought stability to the site then that obviously is good but like you said yourself it will work for now and not when the server gets swamped with requests. Keeping in mind you still have to look at php.ini and my.cnf values do explore the idea of handing off static content to a lighter web server like Lighttpd or Nginx and maybe moving MySQL to another VM.