Bug #10889 99% cpu usage in aspnet_wp.exe with connection pooling enabled
Submitted: 26 May 2005 18:34 Modified: 5 Nov 2007 21:40
Reporter: nik martin Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S4 (Feature request)
Version:1.0.4 OS:Windows (Windows 2000 Advanced Server SP4)
Assigned to: CPU Architecture:Any

[26 May 2005 18:34] nik martin 
Description:
If connection pooling is turned on via the connection string to the MySQLConnection class, when an ASP.Net app starts, the cpu usage will quickly creep up to 99% and stay between 85 and 99%.  Using the CLR Profiler app to debug the issue, I noticed a large amout of activity involving fetching connections from the pool, returning connections to the pool, etc.  I disabled connection pooling, and the CPU usage has stayed below 2%.

That ASP.Net app in question is a very high transaction rate app, making several hundred small, 1-200 byte queries per second, per connection.

How to repeat:
enable connection pooling in the client connection string, then reload the asp.net app
[5 Nov 2007 21:40] Reggie Burnett 
no longer an issue (very old)