C#+Mysql 连接耗尽。我正在使用“使用”；并立即关闭所有连接
在我现在正在制作的应用程序中，我收到此错误：
连接错误：超时已到。 超时时间已过 从池中获取连接。 发生这种情况可能是因为所有 池连接正在使用且最大 已达到池大小。
显然我正在接触连接池中的最大计数。我尽职尽责地对所有连接对象使用“using”，并在函数完成后立即释放它们。
这是 C# 上的，我使用的是 MySql Data Dll。
MySql 的 dotnet 连接器有问题吗？有解决方法吗？
In the application that I am making right now, I am getting this error:
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.
Evidently I am touching max-count in the connection pool. I am dutifully using 'using' with all connection objects and freeing them up immediately when the function is done with them.
This is on C#, and I am using the MySql Data Dll.
Is there something wrong with the dotnet connector for MySql? Is there a workaround?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
首先要检查一些事项：
您是否已验证您的应用程序没有尝试同时使用比连接池允许的数量更多的连接？
如果您在使用连接时执行的操作寿命相当长（无论如何都要避免），则很容易发生这种情况。
您是否传递了 DataReader，而不是在使用完它后正确处理它。这可能会保持连接。
作为权宜之计，您可以尝试在连接字符串中设置“pooling=false”，尽管这会降低性能。
有关使用连接池的详细信息，请参阅 将 Connector/NET 与连接池结合使用
A few things to check first:
Have you verified that your application isn't trying to use more connections concurrently than the number allowed by the connection pool?
This could easily happen if the operations you're doing while using a connection are quite long lived (something to avoid anyway).
Are you passing around a DataReader, rather than disposing it properly when you're done with it. That could be holding on to the connection.
As a stopgap, you could try setting 'pooling=false' in the connection string, although that will cost performance.
For more information on use of connection pooling, see Using Connector/NET with Connection Pooling