Đang Thực Hiện

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 thêm: 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

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

Mã Dự Án: #1696533

Đã 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 Giá)
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 Giá)
6.4
CoVaLiDiTy

can help you. tnx.

$750 USD trong 2 ngày
(150 Đánh Giá)
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 Giá)
6.2
itamarjp

I can investigate and fix this issue.

$750 USD trong 0 ngày
(76 Đánh Giá)
5.7
softcom

I can do this. Please check PMB.

$750 USD trong 2 ngày
(65 Đánh Giá)
5.5
freelancerbuzzo

Check PM, please.

$750 USD trong 5 ngày
(11 Đánh Giá)
4.4
liuxinran

Hi, please check the PM.

$750 USD trong 3 ngày
(15 Đánh Giá)
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 Giá)
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 Giá)
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 Giá)
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 Giá)
0.0
anandanr

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

$900 USD trong 5 ngày
(0 Đánh Giá)
0.0
finecms

We can do what you need.

$1500 USD trong 20 ngày
(0 Đánh Giá)
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 Giá)
0.0
UF32vQE6h

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

$1500 USD trong 1 ngày
(0 Đánh Giá)
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 Giá)
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 Giá)
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 Giá)
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 Thêm

$1200 USD trong 5 ngày
(0 Đánh Giá)
0.0