require_once('mitsql.lib.php');
isOffline() && exit;
-define('MAX_PROC_TIME', 10);
+define('MAX_PROC_TIME', 30);
$baddbs = $badusers = $bad = array();
$result = mysql_query('SHOW FULL PROCESSLIST');
}
mysql_free_result($result);
+print_r($bad);
foreach($bad as $badproc) {
$mailtos = $mailnames = array();
$baddb = mysql_escape_string($badproc['db']);
+ if (empty($baddb)) continue;
$badtime = $badproc['Time'];
$badquery = $badproc['Info'];
- if (empty($baddb)) continue;
$sql = "SELECT User.UserId,User.Name,User.Email
FROM `User`
NATURAL JOIN DBOwner
$mailtos[] = $addy['Email'];
$mailnames[] = $addy['Name'];
}
- if (empty($mailtos)) continue;
+ if (empty($mailtos)) {
+ echo "No email found for $baddb\n";
+ continue;
+ }
$mailto = implode(', ',$mailtos);
$mailname = implode(', ',$mailnames);
- $mailsubj = "[sql] Slow Query on $baddb";
+ $mailsubj = "[sql.mit.edu] Slow Query on $baddb";
$mailbody = "Dear $mailname:
A slow query was found on your database: $baddb
queries to avoid having your queries killed in the future. If you have any
questions, please contact sql@mit.edu.
-This SQL Service is available at sql.mit.edu.
+The SQL Service
+Email: <sql@mit.edu>
+Web: http://sql.mit.edu/
---------------------------------------------------------------------------