awk ' { if(5 ~ /3306/){ if(6 == "ESTABLISHED"){ a[$5]++ } } } END{ for(x in a){ print a[x], x } }'| sed 's/:3306//' | sort -nr -k1