Færdiggjort

Analysis of reasons for slow-running SQL queries

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.

Færdigheder: Apache, MySQL, PHP

Se mere: reasons slow running, mysql slow sql queries, top it problems, table top range, apache mysql slow, cause slow running cpu, sql queries php slow, what is root cause analysis, top ram, sql r, sql in r, r sql, sql queries, slow speed, shr, ram, ni, apache required, reduce sql, analysis required, sshd, mysql running, php mysql load table, php load table, php analysis

Om arbejdsgiveren:
( 1 bedømmelse ) London, United Kingdom

Projekt-ID: #613446

Tildelt til:

TakeReal

Please, see private message.

$100 USD in 2 dage
(1264 bedømmelser)
7.5

17 freelancers are bidding on average $71 for this job

Georgia

I am interested.

$90 USD in 3 dage
(84 bedømmelser)
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 Mere

$80 USD in 5 dage
(2 bedømmelser)
5.8
exsys

Hi, Please check PM.

$40 USD in 0 dage
(20 bedømmelser)
4.8
itamarjp

please check pm

$100 USD in 0 dage
(42 bedømmelser)
4.8
peteruk

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

$100 USD in 2 dage
(13 bedømmelser)
4.6
braincyber

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

$50 USD in 0 dage
(9 bedømmelser)
3.9
gr8Ideas

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

$100 USD på 1 dag
(7 bedømmelser)
3.8
sat12345

Plz check PMB...

$100 USD in 2 dage
(51 bedømmelser)
3.9
garhwalsatyapal

i can fix it

$50 USD in 5 dage
(8 bedømmelser)
3.5
igoryp

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

$30 USD på 1 dag
(2 bedømmelser)
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 Mere

$30 USD in 0 dage
(1 bedømmelse)
1.7
mathemonkey

I'm posting my suggestions to PMB.

$40 USD in 0 dage
(0 bedømmelser)
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 Mere

$50 USD på 1 dag
(0 bedømmelser)
0.0
dimasedu

I can finish this job in a short time

$90 USD in 0 dage
(0 bedømmelser)
0.0
ScottCaldwell

Please see my private message.

$100 USD in 2 dage
(3 bedømmelser)
0.0
AndreyTZ

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

$60 USD in 2 dage
(0 bedømmelser)
0.0