What about "maintain connections across requests" in cfadmin > dsource? Can't that setting effect how many connections are opened?
I had the same trouble when I switched to MySQL 5, but futzing with that setting seems to have fixed it... I think. Might have been something else... Oh, I did have to set the connection limit up in the mysql config file. I'd used the 4gig heavy, which defaulted to 10 I think... I put it at 20 and THAT's what seemed to have fixed it, now that I think about it. :D On 6/22/06, Michael Dinowitz <[EMAIL PROTECTED]> wrote: > > I've got a client that is seeing this error message. (I have not seen the > code/site yet) > "Timed-out trying to get a connection to DB_BOFA. The connection limit has > been reached. " > The only ideas I have is either: > 1. There are too many queries on the page and it's using all of the > possible connections. > 2. The DB or CF is holding DB connections and there are none left in the > 'pool' for use. > > Any possibilities I may have missed? > > Michael Dinowitz > President: House of Fusion > http://www.houseoffusion.com > Publisher: Fusion Authority > http://www.fusionauthority.com > Adobe Community Expert > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244599 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
