In Progress

SQL Database Performance optimization

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..

Skills: Database Administration, MySQL, SQL

See more: sql database program, tune up, sql queries, sql mysql, sql and c, database performance , database optimization, mysql performance optimization, tune optimize, mysql edit database, optimize sql queries, sql optimize, mysql time series, hours access database, running faster, mysql tables rows, optimization database, queries sql, mysql server performance, slow queries, mysql tune, mysql slow queries, tune freebsd, mysql slow, performance optimize

About the Employer:
( 11 reviews ) Margate, United States

Project ID: #4400334

Awarded to:

xcitestudios

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 More

$220 USD in 3 days
(94 Reviews)
6.5

8 freelancers are bidding on average $228 for this job

damirmarkovic

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 More

$220 USD in 4 days
(37 Reviews)
4.7
GandalfTheGrey

I am experienced database and system administrator. I can help you solving your performance issues. More details sent privately.

$357 USD in 4 days
(6 Reviews)
4.1
nibiranijum

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

$150 USD in 3 days
(5 Reviews)
3.7
feninsoftech

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.

$165 USD in 7 days
(3 Reviews)
3.5
aoefmpes

ready to do it

$220 USD in 5 days
(2 Reviews)
2.1
tourala

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 More

$121 USD in 3 days
(2 Reviews)
2.1
permourikis

Hi see your private message

$231 USD in 13 days
(1 Review)
1.9
ramua15

I can do this project

$198 USD in 5 days
(0 Reviews)
0.0
veltrod

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 More

$257 USD in 15 days
(0 Reviews)
0.0