469,270 Members | 1,626 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

Sleeping threads even with wait_timeout on Server2003/XP

Hello All,

Currently we are running MySQL 4.0.17-nt on a Server 2003 machine. I
am having a problem with connections hanging around in a sleep state,
and building up over time. Eventually websites start returning a "No
More Connections" error. Our websites are ASP.NET, and we are using
the CoreLab MySQLDirect.NET component for the .NET interface. Our code
opens and closes each connection explicitly using that API, but
occasionally ASP.NET worker processes start a new thread and one of
the connections (persistent and pooled I assume) is sleeping and never
appears to be reused. This happens over time until there are alot of
them. I thought that setting wait_timeout to a reasonable value, say,
20 minutes, would help clear up those unused connections, but it
appears to have no effect. Time counts on the threads in the process
list just continue forever.

Anyone have any insights?

D. Niemeyer
Xionetic Technologies, Inc.
Jul 20 '05 #1
0 1179

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Moritz Steiner | last post: by
reply views Thread by Shenron | last post: by
3 posts views Thread by siddharthkhare | last post: by
10 posts views Thread by Alfonso Morra | last post: by
4 posts views Thread by cmay | last post: by
2 posts views Thread by puzzlecracker | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.