Debugging sleeping connection with mySQL/optimize mySQL
$30-250 USD
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 |
Project ID: #4166286
About the project
Awarded to:
6 freelancers are bidding on average $213 for this job
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
Hi, Have Gone through your details. We have left a PMB for you plz have a look over there. Thnx Jay JS Infoway Team
Please refer to my private message for how I can help you diagnose and resolve the lag issues. Thanks!
I am experienced Linux system and database administrator. I'll find a source of your performance issues and fix it. More details sent privately.