Re: MySqlConnection doesn't close
Hi,
usualy the pool works as described, and cca 5 connections serves my max. 50-100 users of web app comfortably. I have 30 minutes Wait Timeout, but somtimes it happens, new connections are created instead of using the pooled ones (as Patrik wrote, too). In Administrator, I see number of connections sleeping for hundreds of seconds, sure that they are not in use, nevertheless new and new connections are created. This usualy takes a few minutes and then pooled connections are right used again.
Is it possible, that in some cases the connections are not marked correctly as 'not in use' after they are used? I don't know, where to seek the reason.
I use mysql server 4.1.12 and 1.0.5 connector.
Thanks
Milda
Subject
Written By
Posted
November 07, 2006 02:56PM
November 07, 2006 04:04PM
November 08, 2006 09:21AM
November 08, 2006 02:35PM
November 09, 2006 05:04AM
November 09, 2006 09:52AM
November 18, 2006 08:19AM
November 28, 2006 02:33PM
Re: MySqlConnection doesn't close
January 02, 2007 12:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.