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