查看MySQL show processlist最多的几个ip
查看MySQL show processlist最多的几个ip
[root@www.bkjia.com ]# 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
[root@www.bkjia.com ]# 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
评论暂时关闭