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

Aleksandr Timchenko February 12, 2014

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

1 vote
Answer accepted
FelipeA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 12, 2014

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

Aleksandr Timchenko February 13, 2014

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.

Ryan Dunn April 30, 2014

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

Aleksandr Timchenko May 4, 2014

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.

0 votes
Aleksandr Timchenko February 13, 2014

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
TAGS
AUG Leaders

Atlassian Community Events