Re: Server just hanging (Copying to tmp table)

[Thomas Deliduka]

I created this script htat runs from the command line, initially (you can see the comented lines) I had it simply kill the queries that were running too long but I find that flushing tables actually accomplishes what I want without having to restart. Although as in my post above, I'm still kinda waiting to know if this action is going to kill the people on the websites who are surfing. So far I don't see any indications of that.

Anyway, here's the code, I have it set to run on the command line in a cron job.

#!/usr/bin/php
<?
mysql_connect("localhost","root","thepass");

$result = mysql_query("SHOW FULL PROCESSLIST");
$carray = array("Sleep","Killed","Locked");

while ($row=mysql_fetch_array($result)) {
$process_id=$row["Id"];

if ($row["Time"] > 60 && !in_array($row["Command"],$carray)) {
//$sql="KILL $process_id";
$sql = "FLUSH TABLES";
mysql_query($sql);
//echo "Killed: ". $row["Id"]." ".$row["User"]." ".$row["Host"]." ".$row["db"]." ".$row["Command"]." ".$row["Time"]." ".$row["State"]." ".$row["Info"]."\n";
echo "Flushed Tables";
break;
}
}
?>

I know enough to be dangerous. Thanks for being patient!