<?php
define('MAX_SLEEP_TIME',600);
$hostname = "localhost";
$username = "root";
$password = "123456";
$connect = mysql_connect($hostname, $username, $password);
$result = mysql_query("SHOW PROCESSLIST",$connect);
while ($proc = mysql_fetch_assoc($result)){
if($proc["Command"] == "Sleep" && $proc["Time"] > MAX_SLEEP_TIME){
echo $proc["Id"]."\n";
@mysql_query("KILL ".$proc["Id"],$connect);
}
}
mysql_close($connect);
?>
Kill掉MySQL数据库Sleep进程脚本
最新推荐文章于 2021-01-25 20:57:50 发布