SQL Database Performance optimization
This project was successfully completed by xcitestudios for $220 USD in 3 days.Get free quotes for a project like this
Project Budget$30 - $250 USD
Completed In3 days
I have a gaming server running on FreeBSD, the server has been running for over 5 years and the SQL database has become very slow and unreliable. Sometimes there seems to be sql hiccups and sometimes it hangs for a few minutes. I have tried doing Optimization using MySQL tools but it takes forever and it's not very effective..The database is about 5gb with about 110 tables. I need to do a series of updates on the server which consist of many sql queries that affect thousands of rows...every time I try to run one it seems to take 1-2 hours+ and sometimes it doesn't even finish and times out..not sure if its normal or what.
What I need is for someone to take a quick look at the sql and if they have some sort of special program to optimize the sql then to do that...Also I might need someone to tune up the sql and edit the settings..however it would take me some time to get the root login if it becomes necessary...but I have other ssh logins and webmin access. Anything to make the sql faster if possible..
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online