too many mysql connections

[rossputin]

Hi,

I am hoping someone can give me a little advice and help with database performance (Mysql) with jbpm 3.2.1. I have searched this forum but not found a large amount of data on the topic, although I did see one post about adding DBCP connection pooling to hibernate. Specifically, in stress testing, we recently tested with around 100 users, incidentally mysql was configured for 100 max connections, and I assumed that connection pooling was in place, is this the case?

We got the well known ?too many connections? error anyway, and I am looking for ways to close ?sleeping? connections. When looking at the database ?mysql 5.x? with the gui tools, I see connections remain in sleep mode with the time field value increasing. As I click around in different areas in our web app so I see more connections appearing.
We developed our webapp modelled closely on the jbpm-console sample in 3.2.1.

We have upped the max connections in mysql, but I would still like to know whether anyone has set up connection pooling with jbpm-3.2.1 and mysql, and if there is a way to periodically sweep for and close these sleeping connections?

I read the documentation, but could not get a big picture of how the database works from it.

Thanks for your help in advance,

regards

Ross

[rossputin]

Hi,

I was just wondering whether there are any stress testing benchmarks, or results from testing generally available, this would also help,

thanks in advance,

Ross

[rossputin]

Hi,

is this topic something I should take to a hibernate forum / mailing list?
What I after is some information on settings for hibernate within JBPM, like kill sleeping connections after x amount of time, or connection pooling details,

cheers

Ross

[kukeltje]

I think the numbers you should use should depend on loadtesting your application and tuning the config.