List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:February 27 2012 12:11pm
Subject:Re: file descriptor leak?
View as plain text  
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
> 
> 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?
>>
>> 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"


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
file descriptor leak?Reindl Harald27 Feb
  • Re: file descriptor leak?Johan De Meersman27 Feb
    • Re: file descriptor leak?Reindl Harald27 Feb
      • Re: file descriptor leak?Johan De Meersman27 Feb
        • Re: file descriptor leak?Reindl Harald27 Feb
          • Re: file descriptor leak?Johan De Meersman27 Feb
            • Re: file descriptor leak?Reindl Harald27 Feb
              • Re: file descriptor leak?Johan De Meersman27 Feb
                • Re: file descriptor leak?Reindl Harald27 Feb