#!/bin/bash awk '/tcp.*:3306/{if ($6 == "ESTABLISHED") {a=a+1;b[substr($5,0, length($5)-5)]++}}END{print "TOTAL_IP " length(b); print "ESTABLISHED "a;print "TOTAL_LINK "a}'