any chance you are using the embedded db with a production license key?https://confluence.atlassian.com/support/instance-health-790796828.html
The H2 database is not intended for use for productive purposes
We would strongly recommend that the very next project you do is to migrate from the h2 database to one of the proper databases on the "supported platform" page for your version of Confluence.
H2 databases don't scale well, and are only suitable for systems that you don't mind losing (dev/test/play) - the database can fail catastrophically with no notice and you can lose everything irrecoverably.
Given a completely free choice, PostGreSQL first (because that's what Atlassian use and develop against primarily), MySQL second, Oracle third, and Microsoft-SQL last.
It is not a huge gap between them, and my list is based purely on the experiences of which ones have given me the least and most grief in the past. The software works with, and is supported on, all four.
So, my real life recommendation is actually "whichever one your organisation has the best support for already".
Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events