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..
If you can provide the SQL queries that are being run against it (or the source so I can see them myself) and access to the MySQL server so I can alter table's (my gut here is a few correctly ordered indexes should hel Daha Fazla
8 freelancers are bidding on average $228 for this job
I have years of experience as system/database administrator and developer so I can help you with your problem from different angles. There are a few things to be reviewed and potentially fixed in order to get your data Daha Fazla
I am experienced database and system administrator. I can help you solving your performance issues. More details sent privately.
Hi, I am database expert with more than 6 years of experience. I am also oracle certified. I can provide you best solution. Rgds, Shafiq
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.
Hi! I've read your project description, and I have the required skills on .Database Administration, MySQL, SQL complete the tasks of project. If you have anything to ask you can please. I have expertise to meet your pr Daha Fazla
Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te Daha Fazla