查看mysql show processlist最多的几个ip

[root@ppp ]# mysql -e "show processlist"|awk '{print $3}' |awk -F: '{print $1}' |sort |uniq -c |sort -nr
    320 192.168.240.162
    300 192.168.240.163
    130 192.168.240.161

转载于:https://blog.51cto.com/liang3391/748168