• 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

This widget could not be displayed.

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

This widget could not be displayed.

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
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

203 views 1 3
Join discussion

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