| 1 |
<?php
|
| 2 |
|
| 3 |
include_once('../adodb-perf.inc.php');
|
| 4 |
|
| 5 |
error_reporting(E_ALL);
|
| 6 |
session_start();
|
| 7 |
|
| 8 |
if (isset($_GET)) {
|
| 9 |
foreach($_GET as $k => $v) {
|
| 10 |
if (strncmp($k,'test',4) == 0) $_SESSION['_db'] = $k;
|
| 11 |
}
|
| 12 |
}
|
| 13 |
|
| 14 |
if (isset($_SESSION['_db'])) {
|
| 15 |
$_db = $_SESSION['_db'];
|
| 16 |
$_GET[$_db] = 1;
|
| 17 |
$$_db = 1;
|
| 18 |
}
|
| 19 |
|
| 20 |
echo "<h1>Performance Monitoring</h1>";
|
| 21 |
include_once('testdatabases.inc.php');
|
| 22 |
|
| 23 |
|
| 24 |
function testdb($db)
|
| 25 |
{
|
| 26 |
if (!$db) return;
|
| 27 |
echo "<font size=1>";print_r($db->ServerInfo()); echo " user=".$db->user."</font>";
|
| 28 |
|
| 29 |
$perf = NewPerfMonitor($db);
|
| 30 |
|
| 31 |
# unit tests
|
| 32 |
if (0) {
|
| 33 |
//$DB->debug=1;
|
| 34 |
echo "Data Cache Size=".$perf->DBParameter('data cache size').'<p>';
|
| 35 |
echo $perf->HealthCheck();
|
| 36 |
echo($perf->SuspiciousSQL());
|
| 37 |
echo($perf->ExpensiveSQL());
|
| 38 |
echo($perf->InvalidSQL());
|
| 39 |
echo $perf->Tables();
|
| 40 |
|
| 41 |
echo "<pre>";
|
| 42 |
echo $perf->HealthCheckCLI();
|
| 43 |
$perf->Poll(3);
|
| 44 |
die();
|
| 45 |
}
|
| 46 |
|
| 47 |
if ($perf) $perf->UI(3);
|
| 48 |
}
|
| 49 |
|
| 50 |
?>
|
