I gang

Optimize MYSQL And Apache For High Volume Traffic

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 [url removed, login to view] and [url removed, login to view] 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.

Færdigheder: Linux, System Administrator

Se mere: apache volume, optimize mysql traffic, optimizing request mysql apache load, optimize apache traffic, optimize mysql apache, volume apache server, apache volume settings, apache volume optimization, apache mysql traffic, mysql cpu load, optimize mysql cpu, apache traffic peaks, optimize mysql server, mysql volume peak, optimize apache, optimize server traffic, optimize apache mysql load, web gigs, web for coder, top query, red hat site, gigs video, gigs on, freeze website, all the gigs

Om arbejdsgiveren:
( 2 bedømmelser ) New York, United States

Projekt-ID: #302783

Tildelt til:


Please see PM.

$175 USD in 2 dage
(4 bedømmelser)

10 freelancers are bidding on average $121 for this job


Certified Linux System Administrator ready to work. I can start right away. Kindly check my PM. Regards. Nick.

$100 USD in 0 dage
(205 bedømmelser)

Hi there I am a CCNA/MCSA/Linux+/CEH Certified Ethical Hacker. I have 5+ years in clustered high availability environments and I am the top Linux-Linux Network Security-Ubuntu Expert for the year 2008 on experts-exchan Mere

$99 USD in 2 dage
(77 bedømmelser)

Kindly have a look at PM for solution, Thanks.

$111 USD in 0 dage
(81 bedømmelser)

Please check your PMB. Thank you.

$55 USD på 1 dag
(69 bedømmelser)

I specialize in linux system administration. I have done many apache/mysql optimizations. I will be sure to get your server running perfect for you. Thanks for your time! -Rick

$100 USD in 3 dage
(21 bedømmelser)

I'm an experienced PHP/MySQL programmer. Have Clip Share server optimization tasks before. Please check PMB for details.

$110 USD på 1 dag
(1 bedømmelse)

Please check PMB. Regards, Diego

$250 USD på 1 dag
(0 bedømmelser)

Sounds like too many (too slow) MySQL requests to me, as Database Expert with more than 12 years experiance in designing and optimizing DBs I should be suitable for that job. I have script & sql optimized an ad ser Mere

$150 USD in 3 dage
(0 bedømmelser)

We can do this today.

$55 USD på 1 dag
(0 bedømmelser)

Hi, Give me a chance to Optimize your server with in 2 days. I have good experience in Optimizing servers for mysql and apache. I'm a network manager. You can get the Quality surely. Awaits your reply. T Mere

$60 USD in 2 dage
(0 bedømmelser)