MySQL process optimization

Closed - This job posting has been filled and work has been completed.

Job Description


On one of my dedicated servers we run a membership based site with a large database and hundreds of real time MySQL processes being ran.

Since a short time this is causing a database overload making the site slow and server crashes once in a while. The reason = bad closing of MyQSL processes.

The server runs on cpanel, the site causing the issues is a custom made php site with many mysql connections made by members.

Upon application I will provide the url, the database structure & possible root cause files.

I am looking for a high experienced guy who can identify, analyze and solve the problem within a short timeframe by optimizing on site (files), server & database settings.

PS: No bogus applications. Only relevant information.