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.

[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 Chan]

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

[AndreyevM]

Any news? You made this move?

[ALO]

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!

[AndreyevM]

Any news? You made this move?

[Eva]

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?