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
lsof | grep mysql | grep ESTABLISHED | wc -l
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
> I get the occasional couple of connections difference, but mostly it turns out equal,
> and the difference is never as dramatic as in your case. I wonder what's causing that...
> ----- 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?
>> 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"
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc