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

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

no, the lsof list are incoming connections with
a high port on the other host, to nearly each
one ever connected from rsyslog multiple times

strange thing, this are only maillogs from rsyslog
the other machine logging all no-mail messages
the same way does not show this behavior

mysqld      905 29083    mysql  180u     IPv4             357605        0=
t0        TCP
10.0.0.15:mysql->10.0.0.107:47368 (ESTABLISHED)

mysqld      905 29083    mysql  188u     IPv4            1157085        0=
t0        TCP
10.0.0.15:mysql->10.0.0.6:34938 (ESTABLISHED)


Am 27.02.2012 13:51, schrieb Johan De Meersman:
> And there are no outgoing connections from that host to another mysql s=
erver?
>=20
> ----- Original Message -----
>> From: "Reindl Harald" <h.reindl@stripped>
>> To: mysql@stripped
>> Sent: Monday, 27 February, 2012 1:48:15 PM
>> Subject: Re: file descriptor leak?
>>
>> it is simply not possible that there are 1926 or more
>> connections to mysqld open, limit in my.cnf is 500
>>
>> and it does only affect mysqld
>>
>> otal buffers: 4.6G global + 1.2M per thread (500 max threads)
>> Highest usage of available connections: 16% (82/500)
>> Maximum possible memory usage: 5.2G (60% of installed RAM)
>>
>> the gap is not really closed, only randomly :)
>>
>> lsof -n| grep '^mysqld' | grep ESTABLISHED | wc -l;  netstat -n |
>> grep mysql | grep VERBUNDEN | wc -l
>> 2354
>> 22
>>
>> rkhunter, chkrootkit and unhide are used here since
>> the very first setup
>>
>=20

--=20

Mit besten Gr=C3=BC=C3=9Fen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofm=C3=BChlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm


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

iEYEARECAAYFAk9LhAEACgkQhmBjz394AnlZLwCeNqq84tU+VexBxMZ6A1w5S2Kc
G1UAn17zQDnx9pJlfTLJIVSVbOw4c1UD
=MoI7
-----END PGP SIGNATURE-----

--------------enig4D4D473FAB118E39FD0C87C2--