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

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

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 my=
sql | grep VERBUNDEN | wc -l
2354
22

rkhunter, chkrootkit and unhide are used here since
the very first setup

Am 27.02.2012 13:42, schrieb Johan De Meersman:
> Well, it *did* close the gap by a couple of hundred connections :-)
>=20
> I honestly have no idea what could cause this. I wouldn't immediately t=
hink of a leak in MySQL as those are system tools that *should* check the=
 same location for their stats. Most peculiar.
>=20
> I seem to remember you running mostly redhat systems, maybe poke their =
support? Also, it may be a bit too panicky, but when system tools report =
such wildly differing numbers I involuntarily start reaching for the root=
kit scanners.
>=20
> ----- Original Message -----
>> From: "Reindl Harald" <h.reindl@stripped>
>> To: mysql@stripped
>> Sent: Monday, 27 February, 2012 1:37:26 PM
>> Subject: Re: file descriptor leak?
>>
>> lsof -n| grep '^mysqld' | grep ESTABLISHED | wc -l;  netstat -n |
>> grep mysql | grep VERBUNDEN | wc -l
>> 1926
>> 18

--=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


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

iEYEARECAAYFAk9Le48ACgkQhmBjz394AnllqACgg/WQZKWRxKF/3k2VE0G5Ax4H
OMgAn0qTtpAmVmPgk6ttW78jQl/U2K6h
=uR/a
-----END PGP SIGNATURE-----

--------------enig6ED59A314AF26ABCB87FC586--