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
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);