1
2
3
4
5
6
7
8
9
10
11
12
| <?php
define('MAX_SLEEP_TIME',120);
$connect = mysql_connect("localhost", "root", "password");
$query = mysql_query("SHOW PROCESSLIST", $connect);
while($row=mysql_fetch_array($result)) {
if($row["Command "]=="Sleep" && $row["Time"] > MAX_SLEEP_TIME){
@mysql_query("KILL ".$row["Id"], $connect);
}
}
mysql_close($connect);
unset($connect, $query);
?>
|
