Đã hoàn thành

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.

Kĩ năng: Quản trị cơ sở dữ liệu, Linux, MySQL, Quản trị hệ thống

Xem nhiều hơn: 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

Về Bên Thuê:
( 1 Nhận xét ) Rancho Cucamonga, United States

ID dự án: #1696533

Được trao cho:

designatheme

Professional Here.

$750 USD trong 3 ngày
(16 Đánh Giá)
4.5

19 freelancer đang chào giá trung bình $994 cho công việc này

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 Thêm

$750 USD trong 5 ngày
(119 Nhận xét)
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 Thêm

$900 USD trong 10 ngày
(79 Nhận xét)
6.4
CoVaLiDiTy

can help you. tnx.

$750 USD trong 2 ngày
(150 Nhận xét)
6.3
eperfections

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

$1000 USD trong 5 ngày
(73 Nhận xét)
6.2
itamarjp

I can investigate and fix this issue.

$750 USD trong 0 ngày
(76 Nhận xét)
5.7
softcom

I can do this. Please check PMB.

$750 USD trong 2 ngày
(65 Nhận xét)
5.5
freelancerbuzzo

Check PM, please.

$750 USD trong 5 ngày
(11 Nhận xét)
4.4
liuxinran

Hi, please check the PM.

$750 USD trong 3 ngày
(15 Nhận xét)
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 trong 0 ngày
(10 Nhận xét)
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 trong 3 ngày
(2 Nhận xét)
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 Thêm

$750 USD trong 5 ngày
(0 Nhận xét)
0.0
Jamsheerwork

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

$1000 USD trong 10 ngày
(0 Nhận xét)
0.0
anandanr

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

$900 USD trong 5 ngày
(0 Nhận xét)
0.0
finecms

We can do what you need.

$1500 USD trong 20 ngày
(0 Nhận xét)
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 Thêm

$1200 USD trong 10 ngày
(0 Nhận xét)
0.0
UF32vQE6h

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

$1500 USD trong 1 ngày
(0 Nhận xét)
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 Thêm

$1500 USD trong 5 ngày
(0 Nhận xét)
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 Thêm

$1000 USD trong 19 ngày
(0 Nhận xét)
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 trong 10 ngày
(0 Nhận xét)
0.0
irahmani

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 Thêm

$1200 USD trong 5 ngày
(0 Nhận xét)
0.0