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

[Aleksandr Timchenko]

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

[FelipeA · Accepted solution]

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]

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]

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

[Aleksandr Timchenko]

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

<property name="hibernate.c3p0.min_size">20</property>

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.

[Aleksandr Timchenko]

Thank you for explanation,

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

but now we have following values:

<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.