@chdir(dirname(__FILE__).'/../');
require_once('mitsql.cfg.php');
require_once('mitsql.lib.php');
-define('MAX_PROC_TIME', 10);
+isOffline() && exit;
+
+define('MAX_PROC_TIME', 20);
$baddbs = $badusers = $bad = array();
$result = mysql_query('SHOW FULL PROCESSLIST');
$baddb = mysql_escape_string($badproc['db']);
$badtime = $badproc['Time'];
$badquery = $badproc['Info'];
- mysql_query('KILL '.$badproc['Id']);
if (empty($baddb)) continue;
$sql = "SELECT User.UserId,User.Name,User.Email
FROM `User`
$mailtos[] = $addy['Email'];
$mailnames[] = $addy['Name'];
}
+ if (empty($mailtos)) continue;
$mailto = implode(', ',$mailtos);
$mailname = implode(', ',$mailnames);
$mailsubj = "[sql] Slow Query on $baddb";
$badquery";
- $mailto = 'jwp@mit.edu';
+ mysql_query('KILL '.$badproc['Id']);
mail($mailto,$mailsubj,$mailbody,"From: SQL Service <sql@mit.edu>\r\nBcc: sql@mit.edu\r\n");
}