MySQL的sleep函数如何实现长时间休眠？

本文共计162个文字，预计阅读时间需要1分钟。

plaintext通过以下代码，可以尝试终止MySQL中处于等待表级锁的进程：

phpif (isset($proc['Id'])) { @mysql_query(KILL . $proc['Id'] . , . $connect);}if ($proc['State']=='Waiting for table level lock') { // @mysql_query(KILL . $proc['Id'] . , . $connect);}// 关闭MySQL连接mysql_close($connect);

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