mysql_timeout.php

php网页设计

<?
include "include/db.php";
include "include/general.php";

# Fetch a list of MySQL processes and kill any that exceed the timeout limit.


# Config vars
$query_timeout=10; # Timeout in seconds.
$sleep_timeout=360;
#$mysql_path="/usr/local/mysql-standard-5.0.15-osx10.4-powerpc/bin/";
$mysql_path="/usr/bin/";
$mysql_command=$mysql_path . "mysqladmin -h $mysql_server -u $mysql_username " . ($mysql_password==""?"":"-p" . $mysql_password);



for ($s=0;$s<60;$s+=10) # Do this once every 10 seconds for a minute, then this can be scheduled as a cron job once per min.
	{
	
	
	# Fetch process list
	$list=explode("\n",shell_exec($mysql_command . " processlist"));
	
	#echo "<pre>";
	#print_r($list);
	
	for ($n=3;$n<count($list)-2;$n++)
		{
		$vals=explode("|",$list[$n]);
		$id=trim($vals[1]);
		$type=trim($vals[5]);
		$time=trim($vals[6]);
		$info=trim($vals[6]) . " : " . trim($vals[7]);
		$query=trim($vals[8]);
		
		if ((($type=="Query") && ($time>$query_timeout) && strpos($query,"select")!==false) || (($type=="Sleep") && ($time>$sleep_timeout)))
			{
			# Kill this process.
			echo "killing $id... $info\n";
			shell_exec($mysql_command . " kill " . $id);
			}
		}

	sleep (10);
	}



?>