Too Many TIME_WAIT Connections

(Doc ID 1968865.1)

Last updated on JUNE 27, 2018

Applies to:

MySQL Server - Version 5.1 and later
Generic Linux
Some TCP packets may arrive long time after connection is closed. This may confuse further TCP communication when new connection is established on that socket.
OS works around this problem by keeping socket in special state TIME_WAIT for some time.


netstat shows dozens thousand MySQL connections in TIME_WAIT state.

It may result in lack of free sockets.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms