Indexing in a virtualized environment

For those of you that have virtualized your instances (both application and database), what are your indexing speeds like / how many issues do you have?

Ours seems to vary wildly. We have ~80,000 issues and a background index takes a widely variable amount of time.

4 answers

Hi Adam.

I would look at the storage performance.What are you using to provision storage to the VM?

On system I use quite often with 50K issues background indexing takes about 8 mins.

This KB Article explains how to start about performance troubleshooting.

https://confluence.atlassian.com/kb/testing-disk-access-speed-for-a-java-application-818577561.html

 

Cheers,
Peter T

We've got raided SSDs providing storage to the DB, Machine, and Home Directory servers, something else is amiss here. Mind sharing your virtual machine specs?

Can you provide some examples of the times you are experiencing? Also what kind of monitoring you have on the system, CPU, I/O, memory, users load?

Thanks Peter. We have 24GB RAM with 8 Cores. We're using RAID'ed SSD drives for storage. Anti-virus should not be a factor on the machine. The 5 hour background index was on off-hours (sunday afternoon). 

We have 90,000 issues and a background index on sunday afternoon took over 5 hours.

 

We have  323 custom fields according to System Info, could that be a reason? I've tried to restrict some of them to specific projects, but I still have some room to go there. What is your custom field count at?

I should also say that general JIRA usage is very fast, including searching. The only painful thing is re-indexing.

What type of database are you using and what version (very important as I noticed great difference between MySQL versions for example) ?

Indexing speed might be affected by a lot of factors.

The database server has 4 Cores and 18GB RAM. MS SQL Server 2012. 

Background index times depend on the activity in JIRA at the same time. I'd check your VM server statistics for other VMs using resources (CPU/disk) during the same time. You also want to check you have enough -Xmx set for the JVM heap to avoid large GC pauses

Our  XMX value is "-Xmx6144m", so that seems like plenty, no?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,296 views 12 19
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