There isn't a setting for max idle connections. You can specify the maximum number of connections that can be in the connection pool which will also indicate the maximum number of idle connections there can be. In your case max connections is set to 24 so if the connection pool has reached this limit and currently none of the connections are being used then there will be 24 idle connections in the pool.
Paul -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Victor Balada Diaz Sent: Monday, May 25, 2009 2:16 AM To: [email protected] Subject: [OpenBD] Re: lots of idle connections on MySQL Hello Paul, the only place where i see 24 is in <maxconnections>. If i would like to have at most 10 idle connections but up to 24 max connections, where should i change the value of the pool? Thanks in advance. Regards. On Fri, 2009-05-22 at 11:41 -0400, Paul Bonfanti wrote: > When you create a datasource in OpenBD, by default it will create a > connection pool that has a default max connections value of 24. This means > you can have at most 24 simultaneous connections to the datasource. Let's say > on your site that the most number of simultaneous connections you've ever > received is 10 then you would have 10 idle connections to the database. If > you don't want to use connection pooling then you can set the max connections > value to 0. This will cause there to be 0 idle connections but will hurt > performance since a new connection will need to be made each time you send a > query to the database. > > Paul > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > Victor Balada Diaz > Sent: Thursday, May 21, 2009 6:29 AM > To: [email protected] > Subject: [OpenBD] lots of idle connections on MySQL > > > Hello, > > In our production environment we're seeing that OpenBD is leaving a lot > of idle connections open to the MySQL server. Right now i'm adjusting > server wait_timeout to 3 so connections that are idle for more than 3 > seconds will go away, but i have some questions: > > Why is leaving so many idle connections open? > > How can i control the timeout from the OpenBD side and/or limit how many > idle connections does it have? > > Is there any reason to not do this and keep that many connections open? > > Thanks a lot. > Regards. > > > > > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
