Closed

Mysql Database Expert Needed

I have a large social network style website with many users. Currently there are lots of sleeping queries which keep mysql pegged at 100% cpu usage. The server load is pretty low and appears to have plenty of CPU/RAM/IO left to spare, but the trouble seems to be with connections not closing properly,

I need a mysql expert that can fully review and optimize the database. The database is custom developed so it is important that any changes made are carefully considered.

Please only apply if you are an expert in mysql and have a great deal of experience in optimization.

Here is an example of the latest mysql usage log:

root@server1 [~]# mysqladmin processlist

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

| Id | User | Host | db | Command | Time | State | Info |

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

| 29931815 | leechprotect | localhost | leechprotect | Sleep | 1624 | | |

| 29932034 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 1534 | | |

| 29935325 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 1175 | | |

| 29935956 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 1092 | | |

| 29939275 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 321 | | |

| 29939551 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 623 | | |

| 29941286 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 392 | | |

| 29941389 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 378 | | |

| 29941458 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 369 | | |

| 29942002 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 192 | | |

| 29942414 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 251 | | |

| 29942666 | eximstats | localhost | eximstats | Sleep | 0 | | |

| 29943000 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 178 | | |

| 29943204 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 156 | | |

| 29943250 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 149 | | |

| 29943385 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 134 | | |

| 29943544 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 115 | | |

| 29943850 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 75 | | |

| 29944368 | mpsadmin_user1 | localhost | mpsadmin_555 | Sleep | 5 | | |

| 29944409 | root | localhost | | Query | 0 | | show processlist

Skills: Database Administration, MySQL

See more: leechprotect sleep, root info, optimization expert, mysql database server, sleeping, query optimization, optimize mysql, io, database queries, database optimization, server load log, mysql pretty, database example, queries database, mysql users, mysql review, mysql server example, cpu 100, mysql show, optimization database, mysql cpu load optimize, mysql log, cpu time, custom user mysql, database state

About the Employer:
( 176 reviews ) Knoxville, United States

Project ID: #1297277

13 freelancers are bidding on average $409 for this job

LiveConnector

MySQL expert here, let's get started

$350 USD in 3 days
(8 Reviews)
5.3
Kotkowiczpl

I work at home. My costs are lower, prices more competitive and my workplace is idealy suited to my needs. I have been working remotely for years and I believe this is an ideal solution. I profess the mutual trust prin More

$280 USD in 0 days
(13 Reviews)
4.8
codetrance

I've experience in optimizing database. I can help you with this project. Please check your PMB. Thank you.

$250 USD in 2 days
(22 Reviews)
4.7
GuruDeveloper

I'm running large MySQL cluster for telco's billing - i know a lot about performance and MySQL :) Let's speedup your site! (no upfront money required - payment after completion.

$398 USD in 7 days
(9 Reviews)
4.5
hipper

Mysql expert. Check your inbox please. Thanks!

$400 USD in 5 days
(5 Reviews)
4.3
westcowboy

hi,i'm ready

$450 USD in 2 days
(7 Reviews)
4.2
sobhnath

I am very interested to complete this project, please check your PM Box for further details

$350 USD in 3 days
(6 Reviews)
4.0
softwarevamp

Hello, i can do this in a timely manner look to work with you At your disposal for any query. Regards softwarevamp

$599 USD in 14 days
(14 Reviews)
4.0
richammond

Ready when you are - let's get started!!

$500 USD in 1 day
(6 Reviews)
3.9
vhegz218

I have expert knowledge in optimization of database. I can do this now. Please see PM.

$250 USD in 1 day
(2 Reviews)
3.0
Speacher

Hmmm I'm not so sure of your diagnosis ... please see my private message.

$750 USD in 5 days
(0 Reviews)
0.0
muksvriitk

I faced such problems during starting of my career as software developer. Now, I kind of never face such problem due to my optimim use of database connections. There can be other problems also in the code which might b More

$490 USD in 2 days
(0 Reviews)
0.0
shreeya29

I have good experience to complete this task.

$250 USD in 5 days
(0 Reviews)
0.0