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.rei...@thelounge.net> >> To: "Mailing-List mysql" <mysql@lists.mysql.com> >> 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"
signature.asc
Description: OpenPGP digital signature