Debugging sleeping connection with mySQL/optimize mySQL

IN PROGRESS
Bids
7
Avg Bid (USD)
$189
Project Budget (USD)
$30 - $250

Project Description:
I am having alot of problem with my site www.omgghana.com 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 required:
MySQL, PHP
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 250
in 10 days
$ 250
in 7 days
$ 200
in 5 days
Hire metrixmedia
$ 175
in 3 days
$ 250
in 2 days
$ 50
in 1 days
Hire buntovnik
$ 150
in 4 days