awk '$5 ~ /:3306$/ && $6=="ESTABLISHED"{ip=substr($5,0,length($5)-5);arr[ip]+=1}END{for(i in arr){total_ip++;total_link+=arr[i]};print "TOTAL_IP",total_ip"\n""ESTABLISHED",total_link"\n""TOTAL_LINK",total_link}' nowcoder.txt