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.

Taidot: Linux, PHP, SQL, Järjestelmänvalvoja

Näytä lisää: 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, ver , Sqlite, spl, smp, short tasks

Tietoa työnantajasta:
( 1 arvostelu ) Cairo, Egypt

Projektin tunnus: #458030

Myönnetty käyttäjälle:


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

150 $ USD 1 päivässä
(230 arvostelua)

14 freelancers are bidding on average $189 for this job


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

250 $ USD 5 päivässä
(214 arvostelua)

Kindly have a look at PM, Thanks.

100 $ USD 0 päivässä
(115 arvostelua)

I can do this for you.

250 $ USD 1 päivässä
(85 arvostelua)

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

150 $ USD 0 päivässä
(47 arvostelua)

Hello, Please check PMB for more details.

150 $ USD 3 päivässä
(37 arvostelua)

With over 500 project completed on another freelancing website : [url removed, login to view] I'm certified Microsoft System Administrator htt Lisää

150 $ USD 3 päivässä
(41 arvostelua)

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 Lisää

200 $ USD 8 päivässä
(10 arvostelua)

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

250 $ USD 30 päivässä
(1 arvostelu)

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

150 $ USD 2 päivässä
(2 arvostelua)

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

250 $ USD 2 päivässä
(2 arvostelua)

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 Lisää

200 $ USD 1 päivässä
(1 arvostelu)

plz chk pm

250 $ USD 4 päivässä
(0 arvostelua)

10 years exp in such job

150 $ USD 1 päivässä
(0 arvostelua)