Poor performance on bandana table queries

Still need help?

The Atlassian Community is here for you.

Ask the community

Problem

Thread dumps or stack traces look like this:

	at com.atlassian.confluence.setup.bandana.ConfluenceCachingBandanaPersister.retrieve(ConfluenceCachingBandanaPersister.java(Inlined Compiled Code))
	at com.atlassian.confluence.setup.bandana.ConfluenceCachingBandanaPersister.retrieve(ConfluenceCachingBandanaPersister.java(Compiled Code))
	at com.atlassian.bandana.DefaultBandanaManager.getValue(DefaultBandanaManager.java(Compiled Code))
	at com.atlassian.bandana.DefaultBandanaManager.getValue(DefaultBandanaManager.java(Inlined Compiled Code))
	at com.atlassian.confluence.setup.settings.DefaultSettingsManager.getGlobalSettings(DefaultSettingsManager.java(Inlined Compiled Code))
	at com.atlassian.confluence.util.zip.ConfluenceGzipFilter.useGzip(ConfluenceGzipFilter.java(Compiled Code))

Diagnosis

A way to check whether this is indeed a performance problem is to load and save the Administration >> General Configuration page.

tip/resting Created with Sketch.

The bandana storage is also where plugins store their data. Depending on how it's written, this may be extremely inefficient. Have a look at the bandana table keys, and whether there is a lot of XML data in the BANDANAVALUE column. It's likely due to inefficient plugin data storage.

Cause

Global Configuration settings and plugin data are pulled from the bandana table. This can be inefficient, depending on how much plugin data is stored. More complex plugins that use bandana storage may be inefficient once they begin to scale.

Resolution

  1. Upgrade Confluence. There are performance improvements such as CONF-10552 and many others, including indices added to the bandana table in the database.
  2. Consider increasing the bandana cache. See Cache Performance Tuning. Make sure to check that you're on the correct version for your page. The cache to increase is Settings (Persistence).
    The trade off to a higher cache may be a higher heap space, or garbage collection tuning. See Garbage Collector Performance Issues.

 

 

 

 

 

 

 

 

 

 

 

 

 

   

 

 

 

 

 

 

 

 

 

 

 

 

 

Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.