Project Detail

Description

I run an adult video sharing website and during peak times page loads hang due to what seems to be poorly configured mysql and apache settings. During the peaks, the server load often still has more than 50% load left but pages freeze for often 30 seconds or more before loading. During non-peak moments the server is super fast, pages load in under a second.

As I watch TOP in shell, during the page load hangs, all httpd processes start dieing off and CPU % for mysql quadruples to 200-300%... then suddenly after a few seconds all the HTTPD processes return and mysql cpu load slowly returns to the normal 25-50% then the page will load.

This server is an 8 core (2xintel 5405) with 4 gigs of ram running the latest Red Hat and is only used as a Web/mysql Server. No video is streamed from this server, I have separate server for videos. The site receives average 15k visitors a day so during peak hours it reaches around 1000 uniques/hour. There is no reason for this hanging to happen on such a powerful server with so little traffic, server load averages 1.0 off-peak peak hours (off-peak avg. 800 visitors/hour)

1- I'd like someone to fully optimize mysql and apache. A few tweaks have been done by myself and another coder but I need someone who can analyze the traffic and mysql query loads and make adjustments accordingly. Someone who really knows what they are doing and not just google my.conf and httpd.conf tweaks as I can do that myself.

2- I'd also like this person to properly configure the system cache. I'd like all commonly called files and images to come from cache instead of HD, this should significantly speed things and lesson the load on HD and CPU. Apache has been compiled with mem_cache and disk_cache, you can use those or make better suggestions I am open.