Ok thanks a lot to both of

drzoidberg — Thu, 07 May 2009 07:44:59 +0000

Ok thanks a lot to both of you :)
I assume i have to decrease connection number.

10 x 4 = 40

breakevilaxis — Wed, 06 May 2009 22:50:51 +0000

1 x 4 = 4.
Why do not you change the 10 to 1 or 2 or ...?

mfoss — Wed, 06 May 2009 19:33:00 +0000

drzoidberg wrote:

i can see that i have 40 sleeping mysql connections. 10 for each server.

Right, ejabberd opens the 10 connections when it is started, and the connections are never closed. The ejabberd Guide mentions it:

Quote:

By default ejabberd opens 10 connections to the database for each virtual host.

drzoidberg wrote:

Is there a way to tell ejabberd no to use those connections when it s unnecessary ?
So that mysql can free those connections.

Not possible: I don't see any option for that, and I am not aware of any patch that implements that.