Interesting. I slightly reformatted your commands for both speed and to minimise the time
(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"
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel