MySQL中如何实现延时操作？
- 内容介绍
- 文章标签
- 相关推荐
本文共计161个文字，预计阅读时间需要1分钟。
以下是对给定内容的简化
plaintext使用`MAX_SLEEP_TIME`，如果进程状态为等待表级锁，则尝试杀死进程。
gistfile1.txtMAX_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);
本文共计161个文字，预计阅读时间需要1分钟。
以下是对给定内容的简化
plaintext使用`MAX_SLEEP_TIME`，如果进程状态为等待表级锁，则尝试杀死进程。
gistfile1.txtMAX_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);