Debugging sleeping connection with mySQL/optimize mySQL

In Progress Posted Jan 23, 2013 Paid on delivery
In Progress Paid on delivery

I am having alot of problem with my site [login to view URL] loading times. After consulting my server tech guys i was made to understand the problem is stemming from MYSQL and PHP processes sleeping which in terms causing a lag and killing my server. Please see a sample response below, if anyone can help let me know . Thanks

root@web [~]# mysqladmin processlist

+--------+----------------------+-----------+----------------+----------------+-

| Id | User | Host | db | Command |

+--------+----------------------+-----------+----------------+----------------+-

| 881983 | DELAYED | localhost | eximstats | Delayed insert |

| 939253 | eximstats | localhost | eximstats | Sleep |

| 939308 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 939319 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 939449 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940017 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940069 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940086 | ghkings_wrdp1 | localhost | ghkings_wrdp1 | Sleep |

| 940166 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940167 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940168 | couturea_wrdp1 | localhost | couturea_wrdp1 | Sleep |

| 940169 | omgghana_wrdp1 | localhost | omgghana_wrdp1 | Sleep |

| 940170 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940171 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940172 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940173 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940174 | unauthenticated user | localhost | | Connect |

| 940175 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940176 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940177 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940178 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940179 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940180 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep |

| 940181 | unauthenticated user | localhost | | Connect |

| 940182 | root | localhost | | Query |

| 940183 | unauthenticated user | localhost | | Connect |

MySQL PHP

Project ID: #4166286

About the project

6 proposals Remote project Active Jan 31, 2013

Awarded to:

buntovnik

Hi, I can help you. See your private message board. Regards

$150 USD in 4 days
(2 Reviews)
1.9

6 freelancers are bidding on average $213 for this job

gyaseen1986

Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below https://www.freelancer.com/projects/ More

$200 USD in 5 days
(955 Reviews)
8.7
webzin

Hi Have Gone through your requirement and understood, we are very sure that we can do your needs with your entire satisfaction. We have left a PMB for you plz feel free to have a look over there. Thnx Ram Webzin I More

$250 USD in 7 days
(53 Reviews)
6.2
jsinfoway

Hi, Have Gone through your details. We have left a PMB for you plz have a look over there. Thnx Jay JS Infoway Team

$250 USD in 10 days
(73 Reviews)
6.6
metrixmedia

Please refer to my private message for how I can help you diagnose and resolve the lag issues. Thanks!

$175 USD in 3 days
(40 Reviews)
5.4
GandalfTheGrey

I am experienced Linux system and database administrator. I'll find a source of your performance issues and fix it. More details sent privately.

$250 USD in 2 days
(12 Reviews)
4.5