From: Reindl Harald
Date: February 27 2012 2:23am
Subject: file descriptor leak?
List-Archive: http://lists.mysql.com/mysql/226865
Message-Id: <4F4AE935.3020302@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig83FA8B0F90FE02A02A7F5C17"

--------------enig83FA8B0F90FE02A02A7F5C17
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

mysql-5.5.21

has someone an idea what this large difference between
"netstat" and "lsof" means? am i right that this may be
a descriptor leak leading to troubles over the long?

the full "lsof"-output shows all hosts ever connected
to the server multiple times as "ESTABLISHED"
_____________________________

lsof | grep mysql | grep ESTABLISHED | wc -l
1764

netstat | grep mysql
tcp        0      0 10.0.0.15:3306              10.0.0.102:29642         =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.6:64272           =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.3:50156           =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.103:40381         =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.120:38348         =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.121:58243         =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.109:25173         =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.106:34901         =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.38:47673          =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.107:47368         =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.30:44931          =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.16:27236          =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.120:38357         =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.17:42165          =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.112:61897         =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.110:44953         =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.36:58864          =
   VERBUNDEN   905/mysqld
tcp        0      0 10.0.0.15:3306              10.0.0.113:16230         =
   VERBUNDEN   905/mysqld


--------------enig83FA8B0F90FE02A02A7F5C17
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk9K6TUACgkQhmBjz394Anna9gCgmqxe5BNQwuoTKABV04qkL0Jo
mUYAn1oNhy/NlO8KXglbZ1l22LUEM9YY
=U2j6
-----END PGP SIGNATURE-----

--------------enig83FA8B0F90FE02A02A7F5C17--