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..
8 freelancers are bidding on average $228 for this job
Hi, Database can be optimized by analyzing joins used in queries and Index selection. I have 8 years experience in database development and can do this task for sure.