• 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 votes

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,826 views 12 18
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot