Em Andamento

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

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

Habilidades: Linux, PHP, SQL, Administrador do Sistema

Ver mais: you ver, ver website, ver 5, standard types, service experts, problem website, php split xml file, php version need one, edt ftp, apache web servers, apache experts, sqlite admin, cpanel ftp, apache web services, website migrate, website load, vps admin, ver , sqlite, spl, smp, short tasks, php mysql imap, php db, load information mysql

Acerca do Empregador:
( 1 comentário ) Cairo, Egypt

ID do Projeto: #458030

Premiar a:

Nick1

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

$150 USD em 1 dia
(230 Avaliações)
6.7

14 freelancers estão ofertando em média $189 para este trabalho

VALUEONWEB

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

$250 USD in 5 dias
(214 Comentários)
7.9
hameedkhan

Kindly have a look at PM, Thanks.

$100 USD in 0 dias
(115 Comentários)
6.1
itamarjp

I can do this for you.

$250 USD em 1 dia
(85 Comentários)
5.7
docenta

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

$150 USD in 0 dias
(47 Comentários)
5.1
missil3

Hello, Please check PMB for more details.

$150 USD in 3 dias
(37 Comentários)
5.0
marcinzygmunt

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

$150 USD in 3 dias
(41 Comentários)
5.0
gr8Ideas

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 Mais

$200 USD in 8 dias
(10 Comentários)
4.0
unixworld

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

$250 USD in 30 dias
(1 Comentário)
2.8
openphase

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

$150 USD in 2 dias
(2 Comentários)
2.8
kpetkovic

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

$250 USD in 2 dias
(2 Comentários)
1.7
kumarkr

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 Mais

$200 USD em 1 dia
(1 Comentário)
1.0
sabcreater

plz chk pm

$250 USD in 4 dias
(0 Comentários)
0.0
boianmihailov

10 years exp in such job

$150 USD em 1 dia
(0 Comentários)
0.0