Database & MySQL Work Needed

Avg Bid (USD)
Project Budget (USD)
$250 - $750

Project Description:
One of my website's databases has grown insanely large and needs some serious maintenance in order to remain on our current hosting platform. If you are a MySQL DB expert with PHP experience that knows how to work on dynamicly generated websites, I want to hear from you.

Additional Project Description:
07/20/2013 at 22:41 EDT
My hosting provider HostGator, took the site down today due to the server load from the PHP front end communicating with the MySQL backend.

Here's what they think the problem is...

When looking into this issue on your behalf we do not advise a move to a higher level VPS server as without proper optimization the VPS platform is not sufficient resource wise in order to continue to address the extremely resource intensive mysql queries that are seen in this case.

As such we would strongly recommend looking into indexing large or frequently accessed tables or pruning old, out of date or unneeded information from the effected database, in addition the queries in use may be able to be modified to return less broad results.

Once you believe you have addressed this resource usage issue please reply to this ticket with a description of the changes made in order to bring resource usage under control and we would be happy to re-evaluate your account in order to remove all restrictions as long as no additional resource usage issues exist.

They also claim...

Resolving this situation may be as simple as adding additional indexes to your database, optimizing the queries used, or something equally easy. If not, it may simply be a matter of moving this database to dedicated services, as it may have outgrown a shared environment.

Skills required:
Database Administration, MySQL, PHP
About the employer:
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.

$ 526
in 5 days
$ 600
in 20 days
$ 298
in 6 days
Hire bgeorge
$ 388
in 3 days
$ 500
in 3 days
$ 288
in 6 days
$ 526
in 3 days
Hire mauryacravings
$ 545
in 15 days
Hire farhaoui
$ 515
in 3 days
$ 773
in 21 days