library/adodb/tests/test-perf.php

   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 ?>