17 messages in com.mysql.lists.dotnetRE: Connection Pooling
FromSent OnAttachments
Bill Angus21 Dec 2005 09:56 
Jorge Bastos21 Dec 2005 10:13 
Darren Hill21 Dec 2005 13:40 
Darren Hill21 Dec 2005 13:46 
Darren Hill21 Dec 2005 14:09 
Philip Denno21 Dec 2005 14:13 
Chris Herridge21 Dec 2005 14:16 
Darren Hill21 Dec 2005 14:54 
Darren Hill21 Dec 2005 15:28 
Chris Herridge21 Dec 2005 15:34 
Philip Denno21 Dec 2005 15:37 
Darren Hill21 Dec 2005 15:39 
Bill Angus21 Dec 2005 19:09 
Kevin Turner22 Dec 2005 01:10 
Daniel Fisla22 Dec 2005 08:18 
mdan...@psychtest.com22 Dec 2005 09:43 
David Dindorp27 Dec 2005 03:22 
Subject:RE: Connection Pooling
From:Darren Hill (dhi@ormac.com)
Date:12/21/2005 03:28:37 PM
List:com.mysql.lists.dotnet

I can say now, with confidence, that Close() is being called after each and every db call.

________________________________________ Darren Hill - dhi@ormac.com

Ormac Digital Content Management and IT Solutions www.ormacdigital.com (416) 410-1154

Ormac Management Inc. Management Consulting Services www.ormac.com (416) 533-9756

________________________________________

-----Original Message----- From: Darren Hill [mailto:dhi@ormac.com] Sent: December 21, 2005 5:55 PM To: Chris Herridge; MySQL DotNet Connector Subject: Re: Connection Pooling

Before I say Yes, I'm going to review. But I can say 99% sure I am. I've wrapped all the calls up in an Wrapper that ensures Close and Dispose get called.

-----Original Message----- From: "Chris Herridge" <chr@herridge.co.uk> Date: Wed, 21 Dec 2005 22:16:56 To:<dot@lists.mysql.com> Subject: RE: Connection Pooling

I know this sounds silly but are you calling conn.Close(); in the Page_Unload or Page_Error event handlers?

-----Original Message----- From: Darren Hill [mailto:dhi@ormac.com] Sent: 21 December 2005 22:10 To: dot@lists.mysql.com Subject: RE: Connection Pooling

Further still,

I'm trying ... Pooling=true; max pool size=30; min pool size=5; ... after a few clicks, I run it to the classic "error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."

It appears that the connector is NOT reusing connections, is that not the purpose of pooling? And keeping connections open, etc?

________________________________________ Darren Hill - dhi@ormac.com

Ormac Digital Content Management and IT Solutions www.ormacdigital.com (416) 410-1154

Ormac Management Inc. Management Consulting Services www.ormac.com (416) 533-9756

________________________________________

-----Original Message----- From: Darren Hill [mailto:dhi@ormac.com] Sent: December 21, 2005 4:47 PM To: dot@lists.mysql.com Subject: RE: Connection Pooling

Further,

Since I need to kill the aspnet_wp.exe (or w3wp.exe on the server) in order to release the connections, could it be an issue in the .Net framework?

________________________________________ Darren Hill - dhi@ormac.com

Ormac Digital Content Management and IT Solutions www.ormacdigital.com (416) 410-1154

Ormac Management Inc. Management Consulting Services www.ormac.com (416) 533-9756

________________________________________

-----Original Message----- From: Darren Hill [mailto:dhi@ormac.com] Sent: December 21, 2005 4:41 PM To: dot@lists.mysql.com Subject: Connection Pooling

Ok,

I consider myself fairly educated and savvy when it comes to development, yada yada. I CANNOT get my head around Connection Pooling. I get the idea behind it, and love the idea AND want to take advantage of it, but as soon as I say Pooling=true;, I run into HUGE problems. Specifically running out of connections.

I've done a bunch of reading on the subject and played around with timeouts and such ... can some PLEASE start me down the right path. One scenario is I've got a simple web site, makes one select db call per page (for contents), and it's a fairly active site ... say 3000 hits per day. Can someone tell me what the parameters in the connection string should be in order to maximize performance? Even start me down the right path?

HELP!

________________________________________ Darren Hill - dhi@ormac.com

Ormac Digital Content Management and IT Solutions www.ormacdigital.com (416) 410-1154

Ormac Management Inc. Management Consulting Services www.ormac.com (416) 533-9756

________________________________________

-- MySQL on .NET Mailing List For list archives: http://lists.mysql.com/dotnet To unsubscribe: http://lists.mysql.com/dotnet?unsub=dar@ormac.com

-- MySQL on .NET Mailing List For list archives: http://lists.mysql.com/dotnet To unsubscribe: http://lists.mysql.com/dotnet?unsub=dar@ormac.com

-- MySQL on .NET Mailing List For list archives: http://lists.mysql.com/dotnet To unsubscribe: http://lists.mysql.com/dotnet?unsub=chr@herridge.co.uk

-- MySQL on .NET Mailing List For list archives: http://lists.mysql.com/dotnet To unsubscribe: http://lists.mysql.com/dotnet?unsub=dar@ormac.com

Darren Hill dhi@ormac.com

Ormac Inc. 162 Guelph Street, Suite 215 Georgetown, ON L7G 5X7 Tel: (416) 410-1154 Ext. 2 Fax: (905) 873-6685 http://www.ormac.com

-- MySQL on .NET Mailing List For list archives: http://lists.mysql.com/dotnet To unsubscribe: http://lists.mysql.com/dotnet?unsub=dar@ormac.com