TcpTimedWaitDelay under windows 2022

Question

Having issues connecting to Mysql sporadically . Over 110 connections with TIME_wait status.

I don't see any errors in the event viewer (4231 or 4227)

Any current docs on setting this key for Windows Server 2022/2019 ?

Answer 1

Hello there,

Check to make sure that there is no firewall blocking access to MySQL. Your firewall may be configured on the basis of the application being executed, or the port number used by MySQL for communication (3306 by default).

The MaxUserPort value controls the maximum port number used when an application requests any available user port from the system. Normally, short-lived ports are allocated in the range from 1025 through 65535. The port range is now truly a range with a starting point and with an endpoint. The new default start port is 49152, and the default end port is 65535. This range is in addition to well-known ports that are used by services and by applications.

The port range that is used by the servers can be modified on each server. You adjust this range by using the netsh command, as follows:

netsh int <ipv4|ipv6> set dynamicport <tcp|udp> start=number num=range

Settings that can be Modified to Improve Network Performance https://learn.microsoft.com/en-us/biztalk/technical-guides/settings-that-can-be-modified-to-improve-network-performance

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer–

Answer 2

is StrictTimeWaitSeqCheck necessary?

To ensure that the TCP Timed Wait Delay is enforced by the operating system, the value of the StrictTimeWaitSeqCheck should be changed.

1. Start the registry editor.
2. Navigate to the following entry:

• HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

1. Create a new DWORD (32-bit) Value.
2. Name the value “StrictTimeWaitSeqCheck”.
3. Modify the new entry.
4. Enter 1 for the value.
5. Save the changes.