awk '
BEGIN{
PROCINFO["sorted_in"]="@val_num_desc"
}
$5 ~ /3306/ && $6 == "ESTABLISHED"{
sub(":3306","", $5);
a[$5]++
}
END{
for(x in a){ print a[x], x }
}'
BEGIN{
PROCINFO["sorted_in"]="@val_num_desc"
}
$5 ~ /3306/ && $6 == "ESTABLISHED"{
sub(":3306","", $5);
a[$5]++
}
END{
for(x in a){ print a[x], x }
}'

京公网安备 11010502036488号