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

This widget could not be displayed.

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.

This widget could not be displayed.

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
Community showcase
Posted Monday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

399 views 4 6
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