awk '{
if ($5 ~ /3306$/ && $6 == "ESTABLISHED") {
print($5)
}
}' nowcoder.txt | awk -F ':' '{
map[$1] += 1
}
END {
for (key in map) {
print(map[key], key)
}
}' | sort -nk1 -r
awk '{
if ($5 ~ /3306$/ && $6 == "ESTABLISHED") {
print($5)
}
}' nowcoder.txt | awk -F ':' '{
map[$1] += 1
}
END {
for (key in map) {
print(map[key], key)
}
}' | sort -nk1 -r