Tuer une liste de processus mysql


$result = mysql_query(« SHOW FULL PROCESSLIST »);
while ($row=mysql_fetch_array($result)) {
$process_id=$row["Id"];
if ($row["Time"] > 200 ) {
$sql= »KILL $process_id »;
mysql_query($sql);
}
}

Bookmark and Share

Leave a Reply

You must be logged in to post a comment.