mysql_pwd="123456"
mysql_exec="mysql"
mysql_timeout_dir="/shell"
mysql_timeout_log="$mysql_timeout_dir/mysql_timeout.log"
mysql_kill_timeout_sh="$mysql_timeout_dir/mysql_kill_timeout.sh"
mysql_kill_timeout_log="$mysql_timeout_dir/mysql_kill_timeout.log"
$mysql_exec -uroot -p"$mysql_pwd" -e "select * from information_schema.INNODB_TRX order by trx_started" | awk '{ print $8 , $9}' |
grep -v trx | grep -v '|' | grep -w NULL | sort -rn > $mysql_timeout_log
for i in `cat $mysql_timeout_log | awk '{print $1}'`
do
echo $i >> $mysql_timeout_dir/id.txt
mysql -uroot -p"$mysql_pwd" -e "kill ${i}"
done
$mysql_timeout_log >$mysql_kill_timeout_sh
echo "check start ." >> $mysql_kill_timeout_log
echo `date` >> $mysql_kill_timeout_log
07-08
1207
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
07-08
205
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
07-11
180
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交