1、测试脚本
[root@mysql5 ~]# cat proce.sh
while true
do
mysql -uroot -pmysql -e 'show processlist \G'|grep State >> /root/mysql.log
sleep 1
done

2、tail -f
[root@mysql5 ~]# tail -f mysql.log
State:
State: starting
State:
State: starting
State:
State: starting
State:
State: starting
State:
State: starting
State:
State: starting
State:
State: starting
State:
State: starting
State:
State: starting

3、对mysql.log按行进行排序、去重、计数
[root@mysql5 ~]# sort mysql.log |uniq -c
24State:
24State: starting

4、根据state的信息，对数据库进行分析