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.
Đã trao cho:
19 freelancer đang chào giá trung bình $994 cho công việc này
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