[root@push-5-221 scripts]# mysql -S /var/lib/mysql/3306/mysql.sock -uroot -phlsms_push_Zaq1xsw@ -e "show processlist;"|awk ‘{print $5}‘|awk ‘BEGIN{print "sleep Excute"}{if($NF=="Sleep"){sleeps+=1}}{if($NF=="Execute"){excs+=1}}END{print sleeps,excs}‘ sleep Excute mysql: [Warning] Using a password on the command line interface can be insecure. 24 5 [root@push-5-221 scripts]#
原文：https://www.cnblogs.com/sky-cheng/p/11121683.html