#!/bin/bash grep ESTABLISHED |awk -F ' ' '{print $5}'|grep 3306|awk -F ':' '{arr[$1]++}END{ for (i in arr){ printf "%d %s \n",arr[i],i } }'|sort -nr -k1