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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Friday in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

262 views 11 10
Join discussion

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