Too Many TIME_WAIT Connections (Doc ID 1968865.1)

Last updated on JANUARY 18, 2017

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.

Symptoms

netstat shows dozens thousand MySQL connections in TIME_WAIT state.

It may result in lack of free sockets.

Cause

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