nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JIRA is very slow since a database change (Oracle > MySQL)

oleonardi

We have change of Database system from Oracle to MySQL in order to improve the memory performance because Oracle needs +- 1,5 Gigs of Memory against 400 Megs for MySQL.

Since this modification, JIRA has a lot of problem of lag.

I suppose and hope that is due to the configuration of MySQL and it will be fixable.

Is it possible to help us on the MySQL configuration ?

I join the configuration of JIRA and the my.ini of MySQL.

Thanks for your help.

Accepted answers

All comments

Eva8

My manager has insist of us moving from Oracle to mySQL and frankly I havent see much difference. At the early stage, we are seeing slowness, but that's b/c my manager allocate too little memory for mysql. What settings did you have before with Oracle and now? Do you have customize views or index in Oracle that might not transfer over?

Loredana

Hi,

we are thinking of changing from Oracle to MySQL and I would like to know what are the advantages versus disadvantages. Can anyone share some tips or advice?

Many thanks!

JamieA

Apart from the obvious answers like cost, and the need to have fabulously well-paid DBAs, the main advantage of moving away from oracle is you will not get hit by the many oracle-specific bugs with jira and confluence. Not that oracle is intrinsically worse than other DBMSs per se, the problem is that oracle doesn't get nearly the amount of testing by end-users as the other systems do.

So I say, do it, do it, do it. Except use postgres, that always works well for me and is very easy to set up.

Harry Chan5

Yes, I'd go with Postgres too. It has less issues and is what Atlassian uses internally.

AndreyevM

Any news? You made this move?

AndreyevM

Any news? You made this move?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira