PHP Kill数据库中Sleep的进程

renran421

<title>Kill All Sleep Threads</title>
<?php
/*
* author skipify
*/
$con = mysql_connect("localhost","root","") or die("can not connect database server");
$sql = "show processlist";
$query = mysql_query($sql);
$cv =0;//init 0
$str = "<table border='1'>\n";
$str .= "<tr>\n";
$str .= "<td width='60'>ID</td>\n";
$str .= "<td width='120'>用户名</td>\n";
$str .= "<td width='120'>主机</td>\n";
$str .= "<td width='240'>数据库</td>\n";
$str .= "</tr>\n";
while($r = mysql_fetch_array($query)){
#print_r($r);
if($r["Command"]=="Sleep"){
mysql_query("kill ".$r["Id"]);
$cv++;
//foreach($r as $k=>$v){
//echo "$k...$v\t\t||\t\t";
//}
//echo "<br />";
$str .="<tr>\n";
$str .= "<td>".$r['Id']."</td>\n";
$str .= "<td>".$r['User']."</td>\n";
$str .= "<td>".$r['Host']."</td>\n";
$str .= "<td>".$r['db']."</td>\n";
$str .="</tr>\n";
}
}
$str .= "</table>\n";
echo $str;
echo "<b>You have killed ".$cv." Thread(s)!</b>";
mysql_close($con);
?>


杀掉因为某些原因产生的sleep的mysql线程，可以加入任务计划定时执行，不过还是要优化好程序本身。