We recently upgraded from 3.5.13 to 4.3.
Everything works, but it is really slow. We have upgraded all 4.x compatible plugins, disabled those that are not. We have also re-run both indexes. We upgraded the servers memory to 4.5 gb from 2.5, and assigned 1280mb to confluence's tomcat service. According to the system information page, we have ab out 40% of our heap memory, and 50% of our perm gen memory free.
But even the most basic pages are taking between 20-30 seconds to load. The performance on 3.5.13 was never this slow, is there something on the configuration end that we can do to improve performance?
I wanted to loop back on this one. I opened a ticket with Atlassian (who are excellent by the way).
Basically: we use the Zen Foundation Plugin for our confluence instance, and there was a missing index in our db tables that was killing page load times (it was taking 25-30 seconds to load a page). The Zen plugin was contantly checking for new drafts instead of referncing an index. Finding each page with a draft only a couple of milliseconds, but added up across all the spaces we had.
There seem to be several problems here, all of which are compounding and causing a high page load time:
select count(*) from CONTENT where CONTENTTYPE='DRAFT' and DRAFTPAGEID='0'
They created a patch which I beleive will be in future version of Confluence that creates an index.
Just wanted to clarify the first point here so that in future other user could benefit from it. The patch was about caching database calls on getting page drafts, rather than creating an index. This is the bug report pertaining to that: https://jira.atlassian.com/browse/CONF-26823 which has been fixed in Confluence 4.3.3. So the ultimate resolution is to upgrade your Confluence to 4.3.3 or higher.
Performance problems can be very tricky to troubleshoot, so if you already discarded lack of memory and the atlassian-confluence.log (<confluence-home>/logs) is not showing anything relevant (maybe database latency is high?) I suggest you open a support ticket at https://support.atlassian.com so we can better assist you.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
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!
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