Lowering MySQL threads for confluence

[Jonathon Marshall]

I'm currently testing confluence as an internal documentation store and intranet for a very small company. In my testing I've found that Confluence seems to hold several 10+ mysql threads open at all time. I realize this is probably for performance, but in our case it's unlikely there will ever be more than two people on the site at a time, and the total number of employees can be counted on one hand.

*EDIT

Is there anyway to tune the number of connections used by confluence like you can in JIRA?

https://confluence.atlassian.com/display/JIRA051/Tuning+Database+Connections

[Bruna Griebeler]

Hi Jonathon!

Maybe you can set the number of threads on MySQL itself.

Try changing some parameters on my.cnf, like:

thread_cache_size = 0
wait_timeout = 60
interactive_timeout = 60
max_delayed_threads = 0

This will may help with the idle or unused connections with MySQL.

Hope it helps!

[Jonathon Marshall]

Unfortunately these settings did not change the number of connections remaining open to mysql from Confluence. They also resulted in an overall performance loss (thread_cache_size=0 I assume).

[Jonathon Marshall]

Is there a configuration file similar to this one in JIRA?

https://confluence.atlassian.com/display/JIRA051/Tuning+Database+Connections