Closed

Debugging sleeping connection with mySQL/optimize mySQL

This project was awarded to buntovnik for $150 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
7
Project Description

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 |

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online