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

Beceriler: Veri Tabanı Yönetimi, MySQL, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 11 değerlendirme ) Margate, United States

Proje NO: #4400334



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

%selectedBids___i_period_sub_7% gün içinde 220%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(94 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde220%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(37 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde357%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde165%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

ready to do it

in %bids___i_period_sub_35% gün içinde220%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde121%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Hi see your private message

in %bids___i_period_sub_35% gün içinde231%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

I can do this project

in %bids___i_period_sub_35% gün içinde198%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde257%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)