Analysis of reasons for slow-running SQL queries

Completado Publicado Feb 14, 2010 Pagado a la entrega
Completado Pagado a la entrega

Semi-dedicated web server (512Mb RAM, Xeon(R)CPU E5420 @ [url removed, login to view]) running Apache with:

Linux 2.6.18-028stab066.8

MySQL [url removed, login to view]

PHP 5.1.6-23.2.el5_3

Database is [url removed, login to view] over 39 tables, with 1 table of 28.3Mb.

Load average is frequently in the 2.00-6.00+ range and when running the "top" command, it shows results such as:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

21782 mysql 17 0 376m 49m 5972 S 99.2 9.6 26990:01 mysqld

29712 psaadm 15 0 171m 23m 15m S 0.3 4.6 0:07.12 httpsd

1 root 18 0 10344 732 608 S 0.0 0.1 0:05.97 init

5724 apache 15 0 307m 32m 4932 S 0.0 6.4 0:00.80 httpd

5905 root 15 0 96576 3728 2860 R 0.0 0.7 0:00.09 sshd

This work request is to investigate the cause of this high mysql process and make recommendations as to what can be done to reduce the load average and increase the site's speed.

Notes:

1. I am not looking for generic recommendations - I am looking for someone to point out specific problems and how they could best be fixed.

2. No direct fixing is required as part of this work.

3. Recommendations may lead to future work, including carrying out those suggested fixes.

Thanks.

Apache MySQL PHP

Nº del proyecto: #613446

Sobre el proyecto

17 propuestas Proyecto remoto Activo Feb 20, 2010

Adjudicado a:

TakeReal

Please, see private message.

$100 USD en 2 días
(1264 comentarios)
7.5

17 freelancers están ofertando un promedio de $71 por este trabajo

Georgia

I am interested.

$90 USD en 3 días
(84 comentarios)
7.2
clearware

Hello, we are a company focused on creating custom-made solutions. We have a great experience in optimizing MySQL queries. Also in our team there are sys-admins who could tweak the MySQL and Apache configuration to ac Más

$80 USD en 5 días
(2 comentarios)
5.8
exsys

Hi, Please check PM.

$40 USD en 0 días
(20 comentarios)
4.8
itamarjp

please check pm

$100 USD en 0 días
(42 comentarios)
4.8
peteruk

I can optimise this for you to best suit the host machine.

$100 USD en 2 días
(13 comentarios)
4.6
braincyber

Hi.. Can fix now itself.. Please check your PM.. Thank You

$50 USD en 0 días
(9 comentarios)
3.9
gr8Ideas

Hi, Pl. check PM. I am working on 70 Mysql server for many websites of my organization. regards gr8ideas

$100 USD en 1 día
(7 comentarios)
3.8
sat12345

Plz check PMB...

$100 USD en 2 días
(51 comentarios)
3.9
garhwalsatyapal

i can fix it

$50 USD en 5 días
(8 comentarios)
3.5
igoryp

Hello, I have longtime experience resolve problem like this, This my cup of tee. Thank you.

$30 USD en 1 día
(2 comentarios)
2.6
secpro

I'm a security expert and programmer senior.. i can fix this with no problem ... probably you don't use partitioning methods its new from version 5.1 i can do it in 10 minutes and probably redesign it and increase at Más

$30 USD en 0 días
(1 comentario)
1.7
mathemonkey

I'm posting my suggestions to PMB.

$40 USD en 0 días
(0 comentarios)
0.0
wattwood

I'm a senior systems engineer, I.T. Manager and overall I.T. guru when it comes to Linux-based systems. I can track down the cause of your slow queries and provide recommendations on how to improve performance both on Más

$50 USD en 1 día
(0 comentarios)
0.0
dimasedu

I can finish this job in a short time

$90 USD en 0 días
(0 comentarios)
0.0
ScottCaldwell

Please see my private message.

$100 USD en 2 días
(3 comentarios)
0.0
AndreyTZ

I have been working with databases for 10 years. I think I could solve your problem.

$60 USD en 2 días
(0 comentarios)
0.0