Käynnissä

MySQL database work needed. Resolve slow query/write to DB.

Our company uses a bug tracking system called Redmine, which our Development and IT teams use heavily. Updating issues on the site has slowed down significantly and our IT team has narrowed down the problem to the database. The Redmine system was setup to utilize MySQL running the InnoDB storage engine. The following are some of issues we are presented with:

1. The problem seems to be within a particular table which stores all ticket updates. Running InnoDB does not allow for the optimization of tables.

2. We have dropped the particular table and recreated it from a MySQL dump of production (work done on test server). No significant improvement.

3. We have tuned MySQL for performance using various settings to its configuration file with no significant improvement.

4. Ran multiple python scripts to identify errors in the database such as "MySQL Tuner" and "MySQL Reports," which we then resolved as many issues as we could. However, that yielded no significant results.

5. Rebuilt an entirely new Redmine system in a test environment and restored the DB. This was done in order to rule out that any other database services running on the production server weren't conflicting. This yielded the same result and we received the same write times to the DB.

In conclusion, we have obviously exhausted enough resources and man hours towards this issue. We are seeking a skilled MySQL database administrator to analyze our database and resolve the issues we are confronted with. KNOWLEDGE OF REDMINE IS A PLUS, BUT NOT A REQUIREMENT.

Taidot: Tietokannan hallinto, Linux, MySQL, Järjestelmänvalvoja

Näytä lisää: redmine mysql write slow, mysql database write slow, work environment, services database, python updates, mysql database server, database administrator company, mysql write database slow, issue tracking system, mysql work slow, redmine server, query optimization, python work, mysql test, mysql database , mysql database administrator, db, db query, database performance , database optimization, database administrator, table optimization, mysql performance optimization, work order system, server 2012 python

About the Employer:
( 1 review ) Rancho Cucamonga, United States

Projektin tunnus: #1696533

Myönnetty käyttäjälle:

designatheme

Professional Here.

750 $ USD 3 päivässä
(16 arvostelua)
4.5

19 freelanceria on tarjonnut keskimäärin 994 $ tähän työhön

meral

hi. can help you with this issue(if it fixable at all). i am workign all time with large databases in voip field. i am working as freelancer for more they 9 years and have 12 years experience with linux,10 years with m Lisää

750 $ USD 5 päivässä
(119 arvostelua)
7.7
shakoush2001

Hi I am a CISSP,RHCE,CCNA,MCSA,Linux+ and a CEH. I do have 7+ years experience in System Administration . I have experience in a high availability environment with 100+ servers and more than 500 000+ subscribers, I kno Lisää

900 $ USD 10 päivässä
(79 arvostelua)
6.4
CoVaLiDiTy

can help you. tnx.

750 $ USD 2 päivässä
(150 arvostelua)
6.3
eperfections

Database expert here! We are interested in your project. Please take a look at private message.

1000 $ USD 5 päivässä
(73 arvostelua)
6.2
itamarjp

I can investigate and fix this issue.

750 $ USD 0 päivässä
(76 arvostelua)
5.7
softcom

I can do this. Please check PMB.

750 $ USD 2 päivässä
(65 arvostelua)
5.5
freelancerbuzzo

Check PM, please.

750 $ USD 5 päivässä
(11 arvostelua)
4.4
liuxinran

Hi, please check the PM.

750 $ USD 3 päivässä
(15 arvostelua)
4.1
phpmysqlrocks

I have 3 yr of experience in MySql. I am ready to work with you and complete this project. Thanks

750 $ USD 0 päivässä
(10 arvostelua)
4.0
mannee

hi osantos , your search will be over now, and you would concentrate on work back. please read my PM Thanks

1000 $ USD 3 päivässä
(2 arvostelua)
2.6
jphp4u

I have developed many cms based websites and custom portals in php. I have also developed my own custom cms and developed an email marketing application complete from start to end. Other than these, I have developed ML Lisää

750 $ USD 5 päivässä
(0 arvostelua)
0.0
Jamsheerwork

Hi I am experienced in MySQL databases. I will able to assist you. Regards, Jamsheer MK

1000 $ USD 10 päivässä
(0 arvostelua)
0.0
anandanr

See my PM, i hope we will get this project.

900 $ USD 5 päivässä
(0 arvostelua)
0.0
finecms

We can do what you need.

1500 $ USD 20 päivässä
(0 arvostelua)
0.0
jml5501

Hello I am an expeienced web developer with many years of experience with MySQL databases. Regarding your speed problems, I have 2 potential solutions for you and which one is the most appropriate depends on the nu Lisää

1200 $ USD 10 päivässä
(0 arvostelua)
0.0
UF32vQE6h

Custom Software Development - <b><i>Removed by Admin</i></b>

1500 $ USD 1 päivässä
(0 arvostelua)
0.0
freelancertechnw

Good afternoon. I run a MySQL database with the InnoDB configuration myself. I've also done extensive software development using MySQL Connectors, in desktop apps, MS Office app extensions, ASP.NET, and Perl runnin Lisää

1500 $ USD 5 päivässä
(0 arvostelua)
0.0
BitsLogic

We are a professionally managed IS0 9001:2008 certified web development company. Our team has extensive experience and we have provided services to reputed companies in US, UK, Canada & Europe. Currently we have around Lisää

1000 $ USD 19 päivässä
(0 arvostelua)
0.0
assuranceES

Hello, I have been working in Oracle, SQL Server past 15 years. MySQL may not be the right database for your large database. May work on alternative to handle your database

1500 $ USD 10 päivässä
(0 arvostelua)
0.0
irahmani

We have team of experts with MCSD.net/MCAD.net and MCDBA credentials ready to provide customer guaranteed solutions. Xala Consultants a Norway based ICT firm, established in 2006, is one of the leading providers of e Lisää

1200 $ USD 5 päivässä
(0 arvostelua)
0.0