X-Git-Url: http://andersk.mit.edu/gitweb/sql-web.git/blobdiff_plain/89905822275ff9062a8fefb007b088abee0b0b45..07e7fa78cd0a0483e7c88bd240d0ae06870a8d6c:/cron/checkProcesses.php

diff --git a/cron/checkProcesses.php b/cron/checkProcesses.php
index 67d3a2c..5d1e525 100755
--- a/cron/checkProcesses.php
+++ b/cron/checkProcesses.php
@@ -5,7 +5,7 @@ require_once('mitsql.cfg.php');
 require_once('mitsql.lib.php');
 isOffline() && exit;
 
-define('MAX_PROC_TIME', 30);
+define('MAX_PROC_TIME', 100);
 
 $baddbs = $badusers = $bad = array();
 $result = mysql_query('SHOW FULL PROCESSLIST');
@@ -19,6 +19,8 @@ while ($row = mysql_fetch_assoc($result)){
 mysql_free_result($result);
 
 foreach($bad as $badproc) {
+	mysql_query('KILL '.$badproc['Id']);
+    continue;
 	$mailtos = $mailnames = array();
 	$baddb = mysql_escape_string($badproc['db']);
 	if (empty($baddb)) continue;
@@ -61,7 +63,8 @@ Web: http://sql.mit.edu/
 $badquery";
 
 	mysql_query('KILL '.$badproc['Id']);
-	mail($mailto,$mailsubj,$mailbody,"From: SQL Service <sql@mit.edu>\r\nBcc: sql@mit.edu\r\n");
+	#mail($mailto,$mailsubj,$mailbody,"From: SQL Service <sql@mit.edu>\r\nBcc: sql@mit.edu\r\n");
+    echo $mailbody;
 }
 
 ?>