nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confluence 4.3.3 performance issue

kunitaka

Hi,

I upgraded confluence from 3.5.3 to 4.3.3

After update, I faced with serious performance problem.

All User cant't operate.

My environments are

* MySQL 5.1

* Java 1.7

* Linux

* Cluster Confluence edition but one server

* DB Access with datasource

Sudenlly, Database connection pool is max. It seem that queries are not slow because there are no slow query log.

I can't find out on condition.

It seem that cache statics in 4.3 are ineffective than 3.5.3.

So, amount of queries are increase.

Anyone faced with same problem?

Please help me!!!

Regards

Niku

Accepted answers

JamieA

I have had this consistently too since upgrade to 4.3.1. There is a known issue with the mywork (notifications) plugin, which is exacerbated by the calendar plugin if you have a large user base, but I doubt that's your problem.

Anyway, I still have the problem since applying the fix for that. Been with Atlassian support for about 2 weeks :-(

All comments

JohnA_xb3t2l

Hi Niku,

I believe the two things you will need to do here are increase your database connection pool, because the addition of Active Objects means more calls to the database, and increase your Heap memory allocation because you will probably find that Confluence consumes more memory in newer versions due to the new features.

Database connections: https://confluence.atlassian.com/display/CONFKB/Confluence+Slows+and+Times+Out+During+Periods+of+High+Load+Due+to+DB+Connection+Pool

Increase memory: https://confluence.atlassian.com/display/CONFKB/How+to+Fix+Out+of+Memory+Errors+by+Increasing+Available+Memory#HowtoFixOutofMemoryErrorsbyIncreasingAvailableMemory-Step2:IncreaseAvailableMemory

However, I believe that once you have done this then it should resolve your issue.

All the best,
John

AlysonA

Hi Niku,

Is there any relevant error message being logged in your <confluence-home>/logs/atlassian-confluence.log?

You can start enabling Safe Mode in Confluence Admin > Plugins to see if there's any third party plugin interference.

Cheers.

JamieA

Anyway, I still have the problem since applying the fix for that. Been with Atlassian support for about 2 weeks :-(

kunitaka

Hi, Jamie

Thank you for your reply.

I would like to know your resolution.

What kind of plugins did you ivalid?

I think

Notifications and Tasks - Common Plugin

Notifications and Tasks - Host Plugin

Notifications and Tasks - Confluence Provider Plugin

And

I hope your problem will be fixed.

Thanks

JamieA

I updated the host plugin, but I think the bug only applied to oracle.

How big is your database connection pool? I doubled the size but still getting regular outages.

kunitaka

I tried increase connection, tomcat and yapache and DB.

Now DB thread is 500. But issue in not fixed.

Thanks

Niku

kunitaka

I faced with strange situation.

I changed setting of confluence with admin function.

ex) changed security setting , invalid plugin

Sometimes, after that same issues has occured.(increase Database connections)

I wonder if changed setting makes cleare aplication cache or invalid it.

But it is occured without changed setting.

Maybe, some operations makes cache invalid.

It's so, all access execute SQL query not via cache.

It makes DB connection increased suddenly.

Now I found out that all most of caches are expired every hours.

Surely, issue has occured every hours.

Thanks

kunitaka

I found below.

https://jira.atlassian.com/browse/CONF-26823

My environment is cluster. Function of Cache is deffrent from stand alone.

I afraid this ticket effects on this matter.

Thanks

kunitaka

Maybe, I fixed this issue.

The reason is Java 7.

Confluence cluster edition inclued Oracle Coherence.

The version of cohrence is 3.3.

It is not supported Java 7.

I tried downgrade java from 7 to 6.

Issue has not occured.

Thanks

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence