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.

Kemahiran: Linux, Sistem Admin

Lihat lagi: 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

Tentang Majikan:
( 2 ulasan ) New York, United States

ID Projek: #302783

Dianugerahkan kepada:


Please see PM.

$175 USD dalam 2 hari
(4 Ulasan)

10 pekerja bebas membida secara purata $121 untuk pekerjaan ini


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

$100 USD dalam 0 hari
(205 Ulasan)

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 Lagi

$99 USD dalam 2 hari
(77 Ulasan)

Kindly have a look at PM for solution, Thanks.

$111 USD dalam 0 hari
(81 Ulasan)

Please check your PMB. Thank you.

$55 USD dalam sehari
(69 Ulasan)

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 dalam 3 hari
(21 Ulasan)

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

$110 USD dalam sehari
(1 Ulasan)

Please check PMB. Regards, Diego

$250 USD dalam sehari
(0 Ulasan)

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 Lagi

$150 USD dalam 3 hari
(0 Ulasan)

We can do this today.

$55 USD dalam sehari
(0 Ulasan)

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 Lagi

$60 USD dalam 2 hari
(0 Ulasan)