• Community
  • Products
  • Jira
  • Questions
  • Jira (version 6) freezes with 1.8 million issues. Can anyone contribute with alternatives or validating some ideas?

Jira (version 6) freezes with 1.8 million issues. Can anyone contribute with alternatives or validating some ideas?

I have a lot of data today in a custom JIRA but when it reaches 1.8 million issues it stops working. 

I´m looking for scalability alternatives but I'm not sure if the licensing model allows me to do it ( the text of license is not so specific...)

  • Is it possible to scale JIRA in a cloud (AWS), with multiple instance without additional costs?
  • is it possible to modify database schema? i know that all the issues are stored in a single table, if a could split in different tables I would decrease the load
  • Is it possible to separate JIRA in a web server and multiple database instances with replication without additional costs?

 

If anyone has more alternatives I will be glad to hear all of them smile

2 answers

Hi Fernando,

Check this article: https://confluence.atlassian.com/jirakb/java-8-improves-jira-application-performance-dramatically-689212368.html

We've some customers with a similar issue. That solution has solved the problem.

Check if it's your situation too.

Thanks.

Cheers,

RMRodrigues.

Use a later version of JIRA and Java is almost always a good answer to performance issues smile

1 vote

The bad news first:

>Is it possible to scale JIRA in a cloud (AWS)

No.

>is it possible to modify database schema?

Absolutely no, it has no idea of how you'd handle separate tables

>Is it possible to separate JIRA in a web server and multiple database instances with replication without additional costs?

Nope, it doesn't do any clustering at all

The better news is actually very simple - JIRA data centre is where you need to go.  (The other option is to archive and delete issues, but that has it's own set of complexities)  See https://www.atlassian.com/enterprise/data-center

Thanks a lot for your answer. Just a quick question: Jira's license are a user tier based right? "user tied based" means number of users or means number of web instances? In this case I could scale the database right?

I'm just exploring solutions and trying to figure out if there is a way out. I checked Data Center and it increases my cost seven times in average....

It's the number of active users on licences.

I've no idea what you mean by "scale the database".

 

Scale the database means using a database server and cluster it in AWS for example... 

I don't know if it makes sense in this case...

Ok.  However you do that, bear in mind that

1) JIRA works on a single datasource.  You can do what you want behind the scenes, but it must look like a single datasource

2) It's very rare that the database is the problem when JIRA starts to creak.  The bottlenecks are usually in the index and application server.

Thanks a lot for the information smile

Specially the item 2 helps me a lot... 

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

887 views 3 12
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you