Administrating a heavy loaded Db Website - Experts Only

We currently have a web site that has extensive MySQL Db operations and it daily exceeds 80,000 Pageviews.

But we are experiencing serious outage and slowness every two days and we end up restarting apache and MySQL.

The required tasks include the following:

1) We need to have some sort of profiling to locate the source of the problem (MySQL profiling or Apache profiling), in short we need to know which file has the most time consuming code to reduce it.

2) Advise on what MySQL configuration and Db types that should be implemented

3) Advise whether it's better to use Apache or LightHttpd

4) Advise on whether the current setup is sufficient to play flash videos

5) Advise on whether we should migrate to a VPS and split into multiple servers or one dedicated should be sufficient

6) revise server for unwanted process or services

Some Symptoms:

1) MySQL CPU utilization jumps insanely from 1% to 80% to 160% then jumps back to 50% then to 2%.

2) Upon server outage CPU load on Cpanel is 0.00

3) service is restored by restarting apache and MySQL

Here is some information about the server:

Distribution: Linux [url removed, login to view] [url removed, login to view] #1 SMP EDT 2008 i686 athlon i386 GNU/Linux

#Distro: [url removed, login to view]

#PHP: 5.2.8

#MySQL: Ver 14.12 Distrib [url removed, login to view], for pc-linux-gnu (i686) using readline 5.1

#Server version: Apache/[url removed, login to view]

#Cpanel::Easy::Apache v3.2.0 rev4561

#PHP Modules: bcmath calendar ctype date dom ffmpeg filter ftp gd hash iconv imap json libxml mysql pcre posix Reflection session SimpleXML sockets SPL SQLite standard tokenizer xml xmlreader xmlwriter zlib

#we are extensively using "mod rewrite"

We need to someone that can educate us and help us deliver a better service to our clients

Thank you.

Skills: Linux, PHP, SQL, System Admin

See more: you ver, what is.json, ver website, ver 5, standard c types, service experts, problem website, php split xml file, php 2 version need only one, edt ftp, consuming a web service using php, apache web servers, apache experts, what is json, sqlite admin, cpanel ftp, apache web services, website migrate, website load, vps admin

About the Employer:
( 1 review ) Cairo, Egypt

Project ID: #458030

Awarded to:


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

$150 USD in 1 day
(230 Reviews)

14 freelancers are bidding on average $189 for this job


We have reviewed your project, kindly check pmb for more details

$250 USD in 5 days
(214 Reviews)

Kindly have a look at PM, Thanks.

$100 USD in 0 days
(115 Reviews)

I can do this for you.

$250 USD in 1 day
(85 Reviews)

Please check your private messages. Thanks, [login to view URL]

$150 USD in 0 days
(47 Reviews)

Hello, Please check PMB for more details.

$150 USD in 3 days
(37 Reviews)

With over 500 project completed on another freelancing website : [login to view URL] I'm certified Microsoft System Administrator htt More

$150 USD in 3 days
(41 Reviews)

Reviewed your scenario, that can be easily solve and be fine tuned. I am running a lot websites, i some ample experience on these issues, especially with Mysql and Apache. And about PHP pages, that is sure, u have to i More

$200 USD in 8 days
(10 Reviews)

Hello! Big experience (more than 15 years) of accompaniment of the Unix-systems

$250 USD in 30 days
(1 Review)

I have 15 years experience in Linux/Apache/Mysql administration. I can analyse you problem quickly and provide optimisation solutions.

$150 USD in 2 days
(2 Reviews)

Hi. Will contact you over PMB. Thank you. Kind regards, Kresimir Petkovic

$250 USD in 2 days
(2 Reviews)

Hi, I believe I can help you and guide you to make your site better. I will optimize the database and the inspect code to find the faulty queries and direct you on changes to make the site better in long term. I More

$200 USD in 1 day
(1 Review)

plz chk pm

$250 USD in 4 days
(0 Reviews)

10 years exp in such job

$150 USD in 1 day
(0 Reviews)