cat nowcoder.txt
| grep :3306
| awk '{print $(NF-1),$NF}'
| awk '{split($1,arr,":");print arr[1],$2}'
| awk 'BEGIN{nEST=0;nLk=0} {nEST++;arr[$1]++;nLK++} END{print "TOTAL_IP",length(arr),"\nESTABLISHED",nEST,"\nTOTAL_LINK",nLK}'
cat nowcoder.txt
| grep :3306
| awk '{print $(NF-1),$NF}'
| awk '{split($1,arr,":");print arr[1],$2}'
| awk 'BEGIN{nEST=0;nLk=0} {nEST++;arr[$1]++;nLK++} END{print "TOTAL_IP",length(arr),"\nESTABLISHED",nEST,"\nTOTAL_LINK",nLK}'