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.