.Net Application Slows Down Intermittently due to Thread Starvation
(Doc ID 2951105.1)
Last updated on MAY 26, 2023
Applies to:
MySQL Server - Version 8.0 and laterInformation in this document applies to any platform.
Symptoms
Note: This issue is particular to .Net applications running in Microsoft Windows.
The application environment matches closely to:
Web app: ASP.NET MVC .NET Framework 4.7.2
Hosted in Azure and/or running on Microsoft Windows host.
Web app thread pool custom setting is very high. For example: System.Threading.ThreadPool.SetMinThreads(600, 600)
Connection String includes very high pool settings and low connection timeouts. For example: Max Pool Size=100000;Connection Timeout=5;
MySQL Connector/.Net 8.0.30 version being used.
Connections from the application are working fine and then randomly, the cpu/memory increases and connections start to timeout and/or give errors.
After a period of time, the connection issue resolve and are back to normal.
Appears in the error logs on MySQL Server as:
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |