How to change count of sessions established from Confluence to database?

We have 200 sessions always established from Confluence to database.

Confluence's max number of connector threads is 150. (Tomcat standalone)

maxThreads="150" minSpareThreads="25" maxSpareThreads="75"

As I understood Confluence have internal pool of connections to database.

How to change count of established sessions in this internal pool?

We want minimize them to 150.

Thanks

2 answers

1 accepted

Hi Aleksandr,

You can do this by editting your <install dir>/confluence.cfg.xml, and change the value on the line:

<property name="hibernate.c3p0.max_size">30</property>

to a value that better suit your needs, after that just restart Confluence and you're good to go.

Kind Regards,

Felipe Alencastro

Thank you for explanation,

I try change and check count of sessions after Confluence restart,

but now we have following values:

1
2
<property name="hibernate.c3p0.max_size">150</property>
<property name="hibernate.c3p0.min_size">50</property>

The value 150 is not match with 200 sessions in database.

So I don't see relationship between max_size and count of sessions in database.

Did you ever figure this out? We are having exact same issue.

I got it, I changed property hibernate.c3p0.min_size to 20 in confluence.cfg.xml:

&lt;property name="hibernate.c3p0.min_size"&gt;20&lt;/property&gt;

After restart of Confluence I saw 80 number of sessions.

So my resolution: Number of sessions in database calculate by formula hibernate.c3p0.min_size multiply to 4 times.

Thats why when I had c3p0.min_size equal 50 then number of sessions were 200.

Thank you for explanation,

I try change and check count of sessions after Confluence restart,

but now we have following values:

&lt;property name="hibernate.c3p0.max_size"&gt;150&lt;/property&gt;
&lt;property name="hibernate.c3p0.min_size"&gt;50&lt;/property&gt;

The value 150 is not match with 200 sessions in database.

So I don't see relationship between max_size and count of sessions in database.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Confluence

Three common content challenges + how to manage them

An efficient enterprise content management system, or ECM, is a must-have for companies that create work online (cough   cough, all companies). If content calendars, marketing plans, and bu...

111 views 0 6
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you