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
Linux 终止进程命令—sudo kill -9 <进程号>
2024-07-13 11:50:01 29 阅读