From: Reindl Harald
Date: February 27 2012 12:11pm
Subject: Re: file descriptor leak?
List-Archive: http://lists.mysql.com/mysql/226869
Message-Id: <4F4B72E7.30503@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigD3E62E126F775E37552CDEB7"

--------------enigD3E62E126F775E37552CDEB7
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

i have this only on one machine heavily used
as mail-storage and syslog-server for all
other machines (rsyslog configured for mysql)

netstat | grep mysql | wc -l
19

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

Am 27.02.2012 13:08, schrieb Johan De Meersman:
> Interesting. I slightly reformatted your commands for both speed and to=
 minimise the time between them:
>   (lsof -n| grep '^mysqld' | grep ESTABLISHED | wc -l) & (netstat -n | =
grep 3306 | grep ESTABLISHED | wc -l) & wait
>=20
> I get the occasional couple of connections difference, but mostly it tu=
rns out equal, and the difference is never as dramatic as in your case. I=
 wonder what's causing that...
>=20
>=20
> ----- Original Message -----
>> From: "Reindl Harald" <h.reindl@stripped>
>> To: "Mailing-List mysql" <mysql@stripped>
>> Sent: Monday, 27 February, 2012 3:23:49 AM
>> Subject: file descriptor leak?
>>
>> 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"


--------------enigD3E62E126F775E37552CDEB7
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/

iEYEARECAAYFAk9LcucACgkQhmBjz394AnkDQgCfeX3Z/4KtKnWQ9q+8bTmo9kPy
Av4An0is4y7VQQW5ZTAmUxgrhPBUjxx9
=blIr
-----END PGP SIGNATURE-----

--------------enigD3E62E126F775E37552CDEB7--