#!/bin/bash cat nowcoder.txt| grep 3306| \ awk '{ ips[$5]++; states[$6]++; total_links++; } END { print "TOTAL_IP", length(ips); print "ESTABLISHED", states["ESTABLISHED"]; print "TOTAL_LINK", total_links; }'
#!/bin/bash cat nowcoder.txt| grep 3306| \ awk '{ ips[$5]++; states[$6]++; total_links++; } END { print "TOTAL_IP", length(ips); print "ESTABLISHED", states["ESTABLISHED"]; print "TOTAL_LINK", total_links; }'