Analysis of reasons for slow-running SQL queries
$30-100 USD
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.
Nº del proyecto: #613446
Sobre el proyecto
Adjudicado a:
17 freelancers están ofertando un promedio de $71 por este trabajo
Hi, Pl. check PM. I am working on 70 Mysql server for many websites of my organization. regards gr8ideas