My Oracle Support Banner

.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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.