#!/bin/sh MYSQL_PW=mysqlpass logdir=/root/mysql-log logfile=$logdir/thread.log THR_MAX=50 [ ! -d $logdir ] && mkdir -p $logdir while :; do date >>$logfile thr=`mysql -uroot -p$MYSQL_PW -e "status"|grep Threads|awk '{print $2}'` echo -n "the process is :$thr " >>$logfile [ $thr -gt $THR_MAX ] && mysql -uroot -p$MYSQL_PW -e "show full processlist" >$logdir/`date +%y%m%d-%H%M`-proc.log echo "" >>$logfile echo "===========================================" >>$logfile sleep 30 done
文章出处:http://www.apelearn.com/bbs/thread-22-1-1.html
转载于:https://blog.51cto.com/lyondong/1747819