Tuning SUSE TCP connections

SUSE Linux Enterprise Server SLES Networking
1

I’m trying to determine if I have a tcp connections issue and I’m looking for any information on what the default tcp connections are and how they can be tuned for say mysql.

The issue I am dealing with is I’m running 17 instances of mysql on a single server. There desn’t appear to be a problem with this other than the fact that I have a large amount of time_waits in netstat. Here is a small sample of what they look like:

tcp 0 0 127.0.0.1:3306 127.0.0.1:47441 TIME_WAIT
tcp 0 0 127.0.0.1:47092 127.0.0.1:3315 TIME_WAIT
tcp 0 0 127.0.0.1:46813 127.0.0.1:3317 TIME_WAIT
tcp 0 0 127.0.0.1:3306 127.0.0.1:46659 TIME_WAIT
tcp 0 0 127.0.0.1:41084 127.0.0.1:3312 TIME_WAIT
tcp 0 0 127.0.0.1:49826 127.0.0.1:3321 TIME_WAIT
tcp 0 0 127.0.0.1:38991 127.0.0.1:3314 TIME_WAIT
tcp 0 0 127.0.0.1:38876 127.0.0.1:3314 TIME_WAIT

Someone suggested that mysql may not be getting enough tcp connections. I haven’t change the default of 151 connection for mysql (5.6).

Any information would be helpful.

thank you

2

Hi
This is normal, because TIME_WAIT means the connection has been
closed and it’s just waiting to make sure there are no stray packets
before it really closes.

So maybe it’s a red-herring so to speak?

–
Cheers Malcolm °¿° SUSE Knowledge Partner (Linux Counter #276890)
openSUSE 13.1 (Bottle) (x86_64) GNOME 3.10.2 Kernel 3.11.10-7-desktop
If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below… Thanks!