In Progress

Debugging sleeping connection with mySQL/optimize mySQL

I am having alot of problem with my site [url removed, login to view] 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 |

Skills: MySQL, PHP

See more: id tech, debugging php mysql sleep, my web tech, tech times, sleeping, optimize mysql, mysql connection query, php mysql optimize, connection php mysql, connection mysql, 2013 query, php debugging, mysql query connection, connect query mysql, mysql query php, query optimize, loading optimize, connect connection, loading php mysql, optimize php mysql, stemming, query optimize mysql, eximstats delayed insert, mysql connection, php optimize

About the Employer:
( 0 reviews ) Charlotte, United States

Project ID: #4166286

Awarded to:

buntovnik

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

$150 USD in 4 days
(2 Reviews)
1.8

7 freelancers are bidding on average $189 for this job

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
(66 Reviews)
6.4
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
(48 Reviews)
6.0
linuxfreak1985

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
(62 Reviews)
5.7
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
(38 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
(8 Reviews)
4.1
codedynamic

Hi, I can solve it really quickly. More details in PM.

$50 USD in 1 day
(2 Reviews)
2.5