search

Home >Database >Mysql Tutorial >Kill掉MySQL中所有sleep的client线程_MySQL

Kill掉MySQL中所有sleep的client线程_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:29:511053browse

bitsCN.com

Kill掉MySQL中所有sleep的client线程

 

写了一个脚本，run这个脚本，就可以kill掉MySQL中所有sleep的client线程

vim killsleep.sh#It is used to kill processlist of mysql sleep#!/bin/shwhile :do  n=`mysqladmin processlist -uadmin -pxxxxx|grep -i sleep |wc -l`  date=`date +%Y%m%d/[%H:%M:%S]`  echo $n  if [ "$n" -gt 10 ]  then  for i in `mysqladmin processlist -uadmin -pxxxxxx|grep -i sleep |awk '{print $2}'`  do     mysqladmin -uadmin -pxxxx kill $i  done  echo "sleep is too many I killed it " >> /tmp/sleep.log  echo "$date : $n" >> /tmp/sleep.log  fi                 sleep 1done

 


bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql innodb外键_MySQLNext article：mysql列转行以及年月分组_MySQL

Related articles

See more