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 !! -~----------~----~----~----~------~----~------~--~---
