#!/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;
}'