Re: MySqlConnection doesn't close
Posted by: Miloslav Siroky
Date: January 02, 2007 12:46PM

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

Options: ReplyQuote


Subject
Written By
Posted
November 07, 2006 02:56PM
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.