In Data Center, most heavily used caches have default size limit of 25,000. Due to a typo, Hibernate query cache is set to have just 1000 maximum entries. This might increase pressure on Database in busy instances.

To make matter worse, because of https://jira.atlassian.com/browse/CONFSERVER-54777, the size of this cache cannot be increased via Cache Management UI in Confluence versions prior to 6.7.1

Expected behavior

Hibernate query cache to have default limit of 25,000

Current behavior

Hibernate query cache has a default limit of just 1000

Workaround

For Confluence versions prior to 6.7.1

1. Modify the cache override file at <shared-home>/config/cache-settings-overrides.properties, make sure that this line exists:

   cache.maxEntriesLocalHeap.org.hibernate.cache.internal.StandardQueryCache=25000
   

1. Restart Confluence

For Confluence versions 6.7.1 and later

1. Access Cache Management UI at <confluence-base-url>/admin/cache/showStatistics.action#fullView, adjust size of org.hibernate.cache.internal.StandardQueryCache_v5 to be 25000.

1. Restart Confluence