当前位置 : 主页 > 网络编程 > PHP >

mysql sleep

来源:互联网 收集:自由互联 发布时间:2021-06-28
gistfile1.txt MAX_SLEEP_TIME) { @mysql_query("KILL " . $proc["Id"], $connect); } if ($proc["State"] == "Waiting for table level lock") { //@mysql_query("KILL " . $proc["Id"], $connect); } } //by www.jbxue.com mysql_close($connect); ? $hostn
gistfile1.txt
  MAX_SLEEP_TIME) {   
@mysql_query("KILL " . $proc["Id"], $connect);  
}  
if ($proc["State"] == "Waiting for table level lock") {   
//@mysql_query("KILL " . $proc["Id"], $connect);  
}  
} //by www.jbxue.com  
mysql_close($connect);  
?> 

  
$hostname = "rm-uf60k2oe2b4mfn8two.mysql.rds.aliyuncs.com";  
$username = "sphinx";  
$password = "tysm888A";  
  
$connect = mysqli_connect($hostname, $username, $password);  
$result = mysqli_query($connect,"SHOW PROCESSLIST");  
while ($proc = mysqli_fetch_assoc($result)) {   
if ($proc["Command"] == "Sleep" && $proc["Time"] > MAX_SLEEP_TIME) {   
$a = @mysqli_query($connect,"KILL " . $proc["Id"]);  
}  
if ($proc["State"] == "Waiting for table level lock") {   
//@mysql_query("KILL " . $proc["Id"], $connect);  
}  
} //by www.jbxue.com  
mysqli_close($connect);
网友评论