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, write query, 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

Tietoa työnantajasta:
( 1 arvostelu ) Rancho Cucamonga, United States

Projektin tunnus: #1696533

Myönnetty käyttäjälle:


Professional Here.

$750 USD 3 päivässä
(16 Arvostelua)

19 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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)

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)

can help you. tnx.

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

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

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

I can investigate and fix this issue.

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

I can do this. Please check PMB.

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

Check PM, please.

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

Hi, please check the PM.

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

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)

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)

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)

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

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

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

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

We can do what you need.

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

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)

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

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

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)

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)

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)

We have team of experts with [url removed, login to view] 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)