nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

FelipeA

Hi Aleksandr,

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

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

Kind Regards,

Felipe Alencastro

All comments

FelipeA

Hi Aleksandr,

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

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:

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

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:

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence