adodb_perf Klassenreferenz

Klassendiagramm für adodb_perf:

[Legende]

Öffentliche Methoden
	_CPULoad ()
	MemInfo ()
	CPULoad ()
	Tracer ($sql)
	Explain ($sql, $partial=false)
	InvalidSQL ($numsql=10)
	_SuspiciousSQL ($numsql=10)
	CheckMemory ()
	SuspiciousSQL ($numsql=10)
	ExpensiveSQL ($numsql=10)
	_ExpensiveSQL ($numsql=10)
	DBParameter ($param)
	PollParameters ()
	_DBParameter ($sql)
	WarnCacheRatio ($val)
	clearsql ()
	UI ($pollsecs=5)
	Poll ($secs=5)
	HealthCheckCLI ()
	HealthCheck ($cli=false)
	Tables ($orderby='1')
	CreateLogTable ()
	DoSQLForm ()
	SplitSQL ($sql)
	undomq ($m)
	OptimizeTables ()
	OptimizeTable ($table, $mode=ADODB_OPT_LOW)
	optimizeDatabase ()
Öffentliche, statische Methoden
static	table ($newtable=false)
Datenfelder
	$conn
	$color = '#F0F0F0'
	$table = '<table border=1 bgcolor=white>'
	$titles = '<tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr>'
	$warnRatio = 90
	$tablesSQL = false
	$cliFormat = "%32s => %s \r\n"
	$sql1 = 'sql1'
	$explain = true
	$helpurl = "<a href=http://phplens.com/adodb/reference.functions.fnexecute.and.fncacheexecute.properties.html#logsql>LogSQL help</a>"
	$createTableSQL = false
	$maxLength = 2000
	$_lastLoad

---

Ausführliche Beschreibung

Definiert in Zeile 217 der Datei adodb-perf.inc.php.

---

Dokumentation der Elementfunktionen

_CPULoad

(

)

Definiert in Zeile 242 der Datei adodb-perf.inc.php.

        {
/*

cpu  524152 2662 2515228 336057010
cpu0 264339 1408 1257951 168025827
cpu1 259813 1254 1257277 168031181
page 622307 25475680
swap 24 1891
intr 890153570 868093576 6 0 4 4 0 6 1 2 0 0 0 124 0 8098760 2 13961053 0 0 0 0 0 0 0 0 0 0 0 0 0 16 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
disk_io: (3,0):(3144904,54369,610378,3090535,50936192) (3,1):(3630212,54097,633016,3576115,50951320)
ctxt 66155838
btime 1062315585
processes 69293

*/
                // Algorithm is taken from
                // http://social.technet.microsoft.com/Forums/en-US/winservergen/thread/414b0e1b-499c-411e-8a02-6a12e339c0f1/
                if (strncmp(PHP_OS,'WIN',3)==0) {
                        if (PHP_VERSION == '5.0.0') return false;
                        if (PHP_VERSION == '5.0.1') return false;
                        if (PHP_VERSION == '5.0.2') return false;
                        if (PHP_VERSION == '5.0.3') return false;
                        if (PHP_VERSION == '4.3.10') return false; # see http://bugs.php.net/bug.php?id=31737
                        
                        static $FAIL = false;
                        if ($FAIL) return false;
                        
                        $objName = "winmgmts:{impersonationLevel=impersonate}!\\\\.\\root\\CIMV2";      
                        $myQuery = "SELECT * FROM Win32_PerfFormattedData_PerfOS_Processor WHERE Name = '_Total'";
                        
                        try {
                                @$objWMIService = new COM($objName);
                                if (!$objWMIService) {
                                        $FAIL = true;
                                        return false;
                                }
                
                                $info[0] = -1;
                                $info[1] = 0;
                                $info[2] = 0;
                                $info[3] = 0;
                                foreach($objWMIService->ExecQuery($myQuery) as $objItem)  {
                                                $info[0] = $objItem->PercentProcessorTime();
                                }
                        
                        } catch(Exception $e) {
                                $FAIL = true;
                                echo $e->getMessage();
                                return false;
                        }
                        
                        return $info;
                }
                
                // Algorithm - Steve Blinch (BlitzAffe Online, http://www.blitzaffe.com)
                $statfile = '/proc/stat';
                if (!file_exists($statfile)) return false;
                
                $fd = fopen($statfile,"r");
                if (!$fd) return false;
                
                $statinfo = explode("\n",fgets($fd, 1024));
                fclose($fd);
                foreach($statinfo as $line) {
                        $info = explode(" ",$line);
                        if($info[0]=="cpu") {
                                array_shift($info);  // pop off "cpu"
                                if(!$info[0]) array_shift($info); // pop off blank space (if any)
                                return $info;
                        }
                }
                
                return false;
                
        }

_DBParameter

(

$

sql

)

Definiert in Zeile 605 der Datei adodb-perf.inc.php.

        {
                $savelog = $this->conn->LogSQL(false);
                if (is_array($sql)) {
                global $ADODB_FETCH_MODE;
                
                        $sql1 = $sql[0];
                        $key = $sql[1];
                        if (sizeof($sql)>2) $pos = $sql[2];
                        else $pos = 1;
                        if (sizeof($sql)>3) $coef = $sql[3];
                        else $coef = false;
                        $ret = false;
                        $save = $ADODB_FETCH_MODE;
                        $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
                        if ($this->conn->fetchMode !== false) $savem = $this->conn->SetFetchMode(false);
                        
                        $rs = $this->conn->Execute($sql1);
                        
                        if (isset($savem)) $this->conn->SetFetchMode($savem);
                        $ADODB_FETCH_MODE = $save;
                        if ($rs) {
                                while (!$rs->EOF) {
                                        $keyf = reset($rs->fields);
                                        if (trim($keyf) == $key) {
                                                $ret = $rs->fields[$pos];
                                                if ($coef) $ret *= $coef;
                                                break;
                                        }
                                        $rs->MoveNext();
                                }
                                $rs->Close();
                        }
                        $this->conn->LogSQL($savelog);
                        return $ret;
                } else {
                        if (strncmp($sql,'=',1) == 0) {
                                $fn = substr($sql,1);
                                return $this->$fn();
                        }
                        $sql = str_replace('$DATABASE',$this->conn->database,$sql);
                        $ret = $this->conn->GetOne($sql);
                        $this->conn->LogSQL($savelog);
                        
                        return $ret;
                }
        }

_ExpensiveSQL

(

$

numsql = 10

)

Definiert in Zeile 524 der Datei adodb-perf.inc.php.

        {
                global $ADODB_FETCH_MODE;
                
            $perf_table = adodb_perf::table();
                        $saveE = $this->conn->fnExecute;
                        $this->conn->fnExecute = false;
                        
                        if (isset($_GET['expe']) && isset($_GET['sql'])) {
                                $partial = !empty($_GET['part']);
                                echo "<a name=explain></a>".$this->Explain($_GET['sql'],$partial)."\n";
                        }
                        
                        if (isset($_GET['sql'])) return;
                        
                        $sql1 = $this->sql1;
                        $save = $ADODB_FETCH_MODE;
                        $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
                        if ($this->conn->fetchMode !== false) $savem = $this->conn->SetFetchMode(false);
                        
                        $rs = $this->conn->SelectLimit(
                        "select sum(timer) as total,$sql1,count(*),max(timer) as max_timer,min(timer) as min_timer
                                from $perf_table
                                where {$this->conn->upperCase}({$this->conn->substr}(sql0,1,5))  not in ('DROP ','INSER','COMMI','CREAT')
                                and (tracer is null or tracer not like 'ERROR:%')
                                group by sql1
                                having count(*)>1
                                order by 1 desc",$numsql);
                        if (isset($savem)) $this->conn->SetFetchMode($savem);
                        $this->conn->fnExecute = $saveE;
                        $ADODB_FETCH_MODE = $save;
                        if (!$rs) return "<p>$this->helpurl. ".$this->conn->ErrorMsg()."</p>";
                        $s = "<h3>Expensive SQL</h3>
<font size=1>Tuning the following SQL could reduce the server load substantially</font><br>
<table border=1 bgcolor=white><tr><td><b>Load</b><td><b>Count</b><td><b>SQL</b><td><b>Max</b><td><b>Min</b></tr>\n";
                        $max = $this->maxLength;
                        while (!$rs->EOF) {
                                $sql = $rs->fields[1];
                                $raw = urlencode($sql);
                                if (strlen($raw)>$max-100) {
                                        $sql2 = substr($sql,0,$max-500);
                                        $raw = urlencode($sql2).'&part='.crc32($sql);
                                }
                                $prefix = "<a target=sqle".rand()." href=\"?hidem=1&expe=1&sql=".$raw."&x#explain\">";
                                $suffix = "</a>";
                                if($this->explain == false || strlen($prefix>$max)) {
                                        $prefix = '';
                                        $suffix = '';
                                }
                                $s .= "<tr><td>".adodb_round($rs->fields[0],6)."<td align=right>".$rs->fields[2]."<td><font size=-1>".$prefix.htmlspecialchars($sql).$suffix."</font>".
                                        "<td>".$rs->fields[3]."<td>".$rs->fields[4]."</tr>";
                                $rs->MoveNext();
                        }
                        return $s."</table>";
        }

_SuspiciousSQL

(

$

numsql = 10

)

Definiert in Zeile 445 der Datei adodb-perf.inc.php.

        {
                global $ADODB_FETCH_MODE;
                
            $perf_table = adodb_perf::table();
                        $saveE = $this->conn->fnExecute;
                        $this->conn->fnExecute = false;
                        
                        if (isset($_GET['exps']) && isset($_GET['sql'])) {
                                $partial = !empty($_GET['part']);
                                echo "<a name=explain></a>".$this->Explain($_GET['sql'],$partial)."\n";
                        }
                        
                        if (isset($_GET['sql'])) return;
                        $sql1 = $this->sql1;
                        
                        $save = $ADODB_FETCH_MODE;
                        $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
                        if ($this->conn->fetchMode !== false) $savem = $this->conn->SetFetchMode(false);
                        //$this->conn->debug=1;
                        $rs = $this->conn->SelectLimit(
                        "select avg(timer) as avg_timer,$sql1,count(*),max(timer) as max_timer,min(timer) as min_timer
                                from $perf_table
                                where {$this->conn->upperCase}({$this->conn->substr}(sql0,1,5)) not in ('DROP ','INSER','COMMI','CREAT')
                                and (tracer is null or tracer not like 'ERROR:%')
                                group by sql1
                                order by 1 desc",$numsql);
                        if (isset($savem)) $this->conn->SetFetchMode($savem);
                        $ADODB_FETCH_MODE = $save;
                        $this->conn->fnExecute = $saveE;
                        
                        if (!$rs) return "<p>$this->helpurl. ".$this->conn->ErrorMsg()."</p>";
                        $s = "<h3>Suspicious SQL</h3>
<font size=1>The following SQL have high average execution times</font><br>
<table border=1 bgcolor=white><tr><td><b>Avg Time</b><td><b>Count</b><td><b>SQL</b><td><b>Max</b><td><b>Min</b></tr>\n";
                        $max = $this->maxLength;
                        while (!$rs->EOF) {
                                $sql = $rs->fields[1];
                                $raw = urlencode($sql);
                                if (strlen($raw)>$max-100) {
                                        $sql2 = substr($sql,0,$max-500);
                                        $raw = urlencode($sql2).'&part='.crc32($sql);
                                }
                                $prefix = "<a target=sql".rand()." href=\"?hidem=1&exps=1&sql=".$raw."&x#explain\">";
                                $suffix = "</a>";
                                if ($this->explain == false || strlen($prefix)>$max) {
                                        $suffix = ' ... <i>String too long for GET parameter: '.strlen($prefix).'</i>';
                                        $prefix = '';
                                }
                                $s .= "<tr><td>".adodb_round($rs->fields[0],6)."<td align=right>".$rs->fields[2]."<td><font size=-1>".$prefix.htmlspecialchars($sql).$suffix."</font>".
                                        "<td>".$rs->fields[3]."<td>".$rs->fields[4]."</tr>";
                                $rs->MoveNext();
                        }
                        return $s."</table>";
                
        }

CheckMemory

(

)

Definiert in Zeile 502 der Datei adodb-perf.inc.php.

        {
                return '';
        }

clearsql

(

)

Definiert in Zeile 663 der Datei adodb-perf.inc.php.

        {
                $perf_table = adodb_perf::table();
                $this->conn->Execute("delete from $perf_table where created<".$this->conn->sysTimeStamp);
        }

CPULoad

(

)

Definiert in Zeile 352 der Datei adodb-perf.inc.php.

        {
                $info = $this->_CPULoad();
                if (!$info) return false;
                
                if (strncmp(PHP_OS,'WIN',3)==0) {
                        return (integer) $info[0];
                }else {
                        if (empty($this->_lastLoad)) {
                                sleep(1);
                                $this->_lastLoad = $info;
                                $info = $this->_CPULoad();
                        }
                        
                        $last = $this->_lastLoad;
                        $this->_lastLoad = $info;
                        
                        $d_user = $info[0] - $last[0];
                        $d_nice = $info[1] - $last[1];
                        $d_system = $info[2] - $last[2];
                        $d_idle = $info[3] - $last[3];
                        
                        //printf("Delta - User: %f  Nice: %f  System: %f  Idle: %f<br>",$d_user,$d_nice,$d_system,$d_idle);
                
                        $total=$d_user+$d_nice+$d_system+$d_idle;
                        if ($total<1) $total=1;
                        return 100*($d_user+$d_nice+$d_system)/$total; 
                }
        }

CreateLogTable

(

)

Definiert in Zeile 903 der Datei adodb-perf.inc.php.

        {
                if (!$this->createTableSQL) return false;
                
                $table = $this->table();
                $sql = str_replace('adodb_logsql',$table,$this->createTableSQL);
                $savelog = $this->conn->LogSQL(false);
                $ok = $this->conn->Execute($sql);
                $this->conn->LogSQL($savelog);
                return ($ok) ? true : false;
        }

DBParameter

(

$

param

)

Definiert in Zeile 583 der Datei adodb-perf.inc.php.

        {
                if (empty($this->settings[$param])) return false;
                $sql = $this->settings[$param][1];
                return $this->_DBParameter($sql);
        }

DoSQLForm

(

)

Definiert in Zeile 915 der Datei adodb-perf.inc.php.

        {
        
                
                $PHP_SELF = htmlspecialchars($_SERVER['PHP_SELF']);
                $sql = isset($_REQUEST['sql']) ? $_REQUEST['sql'] : '';

                if (isset($_SESSION['phplens_sqlrows'])) $rows = $_SESSION['phplens_sqlrows'];
                else $rows = 3;
                
                if (isset($_REQUEST['SMALLER'])) {
                        $rows /= 2;
                        if ($rows < 3) $rows = 3;
                        $_SESSION['phplens_sqlrows'] = $rows;
                }
                if (isset($_REQUEST['BIGGER'])) {
                        $rows *= 2;
                        $_SESSION['phplens_sqlrows'] = $rows;
                }
                
?>

<form method="POST" action="<?php echo $PHP_SELF ?>">
<table><tr>
<td> Form size: <input type="submit" value=" &lt; " name="SMALLER"><input type="submit" value=" &gt; &gt; " name="BIGGER">
</td>
<td align=right>
<input type="submit" value=" Run SQL Below " name="RUN"><input type=hidden name=do value=dosql>
</td></tr>
  <tr>
  <td colspan=2><textarea rows=<?php print $rows; ?> name="sql" cols="80"><?php print htmlspecialchars($sql) ?></textarea>
  </td>
  </tr>
 </table>
</form>

<?php
                if (!isset($_REQUEST['sql'])) return;
                
                $sql = $this->undomq(trim($sql));
                if (substr($sql,strlen($sql)-1) === ';') {
                        $print = true;
                        $sqla = $this->SplitSQL($sql);
                } else  {
                        $print = false;
                        $sqla = array($sql);
                }
                foreach($sqla as $sqls) {

                        if (!$sqls) continue;
                        
                        if ($print) {
                                print "<p>".htmlspecialchars($sqls)."</p>";
                                flush();
                        }
                        $savelog = $this->conn->LogSQL(false);
                        $rs = $this->conn->Execute($sqls);
                        $this->conn->LogSQL($savelog);
                        if ($rs && is_object($rs) && !$rs->EOF) {
                                rs2html($rs);
                                while ($rs->NextRecordSet()) {
                                        print "<table width=98% bgcolor=#C0C0FF><tr><td>&nbsp;</td></tr></table>";
                                        rs2html($rs);
                                }
                        } else {
                                $e1 = (integer) $this->conn->ErrorNo();
                                $e2 = $this->conn->ErrorMsg();
                                if (($e1) || ($e2)) {
                                        if (empty($e1)) $e1 = '-1'; // postgresql fix
                                        print ' &nbsp; '.$e1.': '.$e2;
                                } else {
                                        print "<p>No Recordset returned<br></p>";
                                }
                        }
                } // foreach
        }

ExpensiveSQL

(

$

numsql = 10

)

Definiert in Zeile 513 der Datei adodb-perf.inc.php.

        {
                return adodb_perf::_ExpensiveSQL($numsql);
        }

Explain	(	$	sql,
		$	partial = false
	)

Erneute Implementation in perf_db2, perf_mssql, perf_mssqlnative, perf_mysql und perf_postgres.

Definiert in Zeile 418 der Datei adodb-perf.inc.php.

        {       
                return false;
        }

HealthCheck

(

$

cli = false

)

Erneute Implementation in perf_mssql und perf_mssqlnative.

Definiert in Zeile 822 der Datei adodb-perf.inc.php.

        {
                $saveE = $this->conn->fnExecute;
                $this->conn->fnExecute = false; 
                if ($cli) $html = '';
                else $html = $this->table.'<tr><td colspan=3><h3>'.$this->conn->databaseType.'</h3></td></tr>'.$this->titles;
                
                $oldc = false;
                $bgc = '';
                foreach($this->settings as $name => $arr) {
                        if ($arr === false) break;
                        
                        if (!is_string($name)) {
                                if ($cli) $html .= " -- $arr -- \n";
                                else $html .= "<tr bgcolor=$this->color><td colspan=3><i>$arr</i> &nbsp;</td></tr>";
                                continue;
                        }
                        
                        if (!is_array($arr)) break;
                        $category = $arr[0];
                        $how = $arr[1];
                        if (sizeof($arr)>2) $desc = $arr[2];
                        else $desc = ' &nbsp; ';
                        
                        
                        if ($category == 'HIDE') continue;
                        
                        $val = $this->_DBParameter($how);
                        
                        if ($desc && strncmp($desc,"=",1) === 0) {
                                $fn = substr($desc,1);
                                $desc = $this->$fn($val);
                        }
                        
                        if ($val === false) {
                                $m = $this->conn->ErrorMsg();
                                $val = "Error: $m"; 
                        } else {
                                if (is_numeric($val) && $val >= 256*1024) {
                                        if ($val % (1024*1024) == 0) {
                                                $val /= (1024*1024);
                                                $val .= 'M';
                                        } else if ($val % 1024 == 0) {
                                                $val /= 1024;
                                                $val .= 'K';
                                        }
                                        //$val = htmlspecialchars($val);
                                }
                        }
                        if ($category != $oldc) {
                                $oldc = $category;
                                //$bgc = ($bgc == ' bgcolor='.$this->color) ? ' bgcolor=white' : ' bgcolor='.$this->color;
                        }
                        if (strlen($desc)==0) $desc = '&nbsp;';
                        if (strlen($val)==0) $val = '&nbsp;';
                        if ($cli) {
                                $html  .= str_replace('&nbsp;','',sprintf($this->cliFormat,strip_tags($name),strip_tags($val),strip_tags($desc)));
                                
                        }else {
                                $html .= "<tr$bgc><td>".$name.'</td><td>'.$val.'</td><td>'.$desc."</td></tr>\n";
                        }
                }
                
                if (!$cli) $html .= "</table>\n";
                $this->conn->fnExecute = $saveE;
                        
                return $html;   
        }

HealthCheckCLI

(

)

Definiert in Zeile 813 der Datei adodb-perf.inc.php.

        {
                return $this->HealthCheck(true);
        }

InvalidSQL

(

$

numsql = 10

)

Definiert in Zeile 423 der Datei adodb-perf.inc.php.

        {
        
                if (isset($_GET['sql'])) return;
                $s = '<h3>Invalid SQL</h3>';
                $saveE = $this->conn->fnExecute;
                $this->conn->fnExecute = false;
        $perf_table = adodb_perf::table();
                $rs = $this->conn->SelectLimit("select distinct count(*),sql1,tracer as error_msg from $perf_table where tracer like 'ERROR:%' group by sql1,tracer order by 1 desc",$numsql);//,$numsql);
                $this->conn->fnExecute = $saveE;
                if ($rs) {
                        $s .= rs2html($rs,false,false,false,false);
                } else
                        return "<p>$this->helpurl. ".$this->conn->ErrorMsg()."</p>";
                
                return $s;
        }

MemInfo

(

)

Definiert in Zeile 320 der Datei adodb-perf.inc.php.

        {
                /*

        total:    used:    free:  shared: buffers:  cached:
Mem:  1055289344 917299200 137990144        0 165437440 599773184
Swap: 2146775040 11055104 2135719936
MemTotal:      1030556 kB
MemFree:        134756 kB
MemShared:           0 kB
Buffers:        161560 kB
Cached:         581384 kB
SwapCached:       4332 kB
Active:         494468 kB
Inact_dirty:    322856 kB
Inact_clean:     24256 kB
Inact_target:   168316 kB
HighTotal:      131064 kB
HighFree:         1024 kB
LowTotal:       899492 kB
LowFree:        133732 kB
SwapTotal:     2096460 kB
SwapFree:      2085664 kB
Committed_AS:   348732 kB
                */
        }

optimizeDatabase

(

)

Reorganise current database. Default implementation loops over all MetaTables() and optimize each using optmizeTable()

Autor:

Markus Staab

Rückgabe:

Returns true on success and false on error

Definiert in Zeile 1080 der Datei adodb-perf.inc.php.

    {
        $conn = $this->conn;
        if ( !$conn) return false;
        
        $tables = $conn->MetaTables( 'TABLES');
        if ( !$tables ) return false;

        foreach( $tables as $table) {
            if ( !$this->optimizeTable( $table)) {
                return false;
            }
        }
      
        return true;
    }

OptimizeTable	(	$	table,
		$	mode = ADODB_OPT_LOW
	)

Reorganise the table-indices/statistics/.. depending on the given mode. Default Implementation throws an error.

Parameter:

	string	table name of the table to optimize
	int	mode optimization-mode ADODB_OPT_HIGH for full optimization ADODB_OPT_LOW for CPU-less optimization Default is LOW ADODB_OPT_LOW

Autor:

Markus Staab

Rückgabe:

Returns true on success and false on error

Definiert in Zeile 1066 der Datei adodb-perf.inc.php.

    {
        ADOConnection::outp( sprintf( "<p>%s: '%s' not implemented for driver '%s'</p>", __CLASS__, __FUNCTION__, $this->conn->databaseType));
        return false;
    }

OptimizeTables

(

)

Definiert in Zeile 1035 der Datei adodb-perf.inc.php.

    {
        $args = func_get_args();
        $numArgs = func_num_args();
        
        if ( $numArgs == 0) return false;
        
        $mode = ADODB_OPT_LOW; 
        $lastArg = $args[ $numArgs - 1];
        if ( !is_string($lastArg)) {
            $mode = $lastArg;
            unset( $args[ $numArgs - 1]);
        }
        
        foreach( $args as $table) {
            $this->optimizeTable( $table, $mode);
        }
        }

Poll

(

$

secs = 5

)

Definiert in Zeile 771 der Datei adodb-perf.inc.php.

        {
                $this->conn->fnExecute = false;
                //$this->conn->debug=1;
                if ($secs <= 1) $secs = 1;
                echo "Accumulating statistics, every $secs seconds...\n";flush();
                $arro = $this->PollParameters();
                $cnt = 0;
                set_time_limit(0);
                sleep($secs);
                while (1) {

                        $arr = $this->PollParameters();
                        
                        $hits   = sprintf('%2.2f',$arr[0]);
                        $reads  = sprintf('%12.4f',($arr[1]-$arro[1])/$secs);
                        $writes = sprintf('%12.4f',($arr[2]-$arro[2])/$secs);
                        $sess = sprintf('%5d',$arr[3]);
                        
                        $load = $this->CPULoad();
                        if ($load !== false) {
                                $oslabel = 'WS-CPU%';
                                $osval = sprintf(" %2.1f  ",(float) $load);
                        }else {
                                $oslabel = '';
                                $osval = '';
                        }
                        if ($cnt % 10 == 0) echo " Time   ".$oslabel."   Hit%   Sess           Reads/s          Writes/s\n"; 
                        $cnt += 1;
                        echo date('H:i:s').'  '.$osval."$hits  $sess $reads $writes\n";
                        flush();
                        
                        if (connection_aborted()) return;
                        
                        sleep($secs);
                        $arro = $arr;
                }
        }

PollParameters

(

)

Definiert in Zeile 593 der Datei adodb-perf.inc.php.

        {
                $arr[0] = (float)$this->DBParameter('data cache hit ratio');
                $arr[1] = (float)$this->DBParameter('data reads');
                $arr[2] = (float)$this->DBParameter('data writes');
                $arr[3] = (integer) $this->DBParameter('current connections');
                return $arr;
        }

SplitSQL

(

$

sql

)

Definiert in Zeile 992 der Datei adodb-perf.inc.php.

        {
                $arr = explode(';',$sql);
                return $arr;
        }

SuspiciousSQL

(

$

numsql = 10

)

Definiert in Zeile 508 der Datei adodb-perf.inc.php.

        {
                return adodb_perf::_SuspiciousSQL($numsql);
        }

static table

(

$

newtable = false

)

[static]

Definiert in Zeile 232 der Datei adodb-perf.inc.php.

    {
        static $_table;

        if (!empty($newtable))  $_table = $newtable;
                if (empty($_table)) $_table = 'adodb_logsql';
        return $_table;
    }

Tables

(

$

orderby = '1'

)

Definiert in Zeile 891 der Datei adodb-perf.inc.php.

        {
                if (!$this->tablesSQL) return false;
                
                $savelog = $this->conn->LogSQL(false);
                $rs = $this->conn->Execute($this->tablesSQL.' order by '.$orderby);
                $this->conn->LogSQL($savelog);
                $html = rs2html($rs,false,false,false,false);
                return $html;
        }

Tracer

(

$

sql

)

Definiert in Zeile 382 der Datei adodb-perf.inc.php.

        {
        $perf_table = adodb_perf::table();
                $saveE = $this->conn->fnExecute;
                $this->conn->fnExecute = false;
                
                global $ADODB_FETCH_MODE;
                $save = $ADODB_FETCH_MODE;
                $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
                if ($this->conn->fetchMode !== false) $savem = $this->conn->SetFetchMode(false);
                                
                $sqlq = $this->conn->qstr($sql);
                $arr = $this->conn->GetArray(
"select count(*),tracer 
        from $perf_table where sql1=$sqlq 
        group by tracer
        order by 1 desc");
                $s = '';
                if ($arr) {
                        $s .= '<h3>Scripts Affected</h3>';
                        foreach($arr as $k) {
                                $s .= sprintf("%4d",$k[0]).' &nbsp; '.strip_tags($k[1]).'<br>';
                        }
                }
                
                if (isset($savem)) $this->conn->SetFetchMode($savem);
                $ADODB_CACHE_MODE = $save;
                $this->conn->fnExecute = $saveE;
                return $s;
        }

UI

(

$

pollsecs = 5

)

Definiert in Zeile 673 der Datei adodb-perf.inc.php.

        {
        global $ADODB_LOG_CONN;
        
    $perf_table = adodb_perf::table();
        $conn = $this->conn;
        
        $app = $conn->host;
        if ($conn->host && $conn->database) $app .= ', db=';
        $app .= $conn->database;
        
        if ($app) $app .= ', ';
        $savelog = $this->conn->LogSQL(false);  
        $info = $conn->ServerInfo();
        if (isset($_GET['clearsql'])) {
                $this->clearsql();
        }
        $this->conn->LogSQL($savelog);
        
        // magic quotes
        
        if (isset($_GET['sql']) && get_magic_quotes_gpc()) {
                $_GET['sql'] = $_GET['sql'] = str_replace(array("\\'",'\"'),array("'",'"'),$_GET['sql']);
        }
        
        if (!isset($_SESSION['ADODB_PERF_SQL'])) $nsql = $_SESSION['ADODB_PERF_SQL'] = 10;
        else  $nsql = $_SESSION['ADODB_PERF_SQL'];
        
        $app .= $info['description'];
        
        
        if (isset($_GET['do'])) $do = $_GET['do'];
        else if (isset($_POST['do'])) $do = $_POST['do'];
         else if (isset($_GET['sql'])) $do = 'viewsql';
         else $do = 'stats';
         
        if (isset($_GET['nsql'])) {
                if ($_GET['nsql'] > 0) $nsql = $_SESSION['ADODB_PERF_SQL'] = (integer) $_GET['nsql'];
        }
        echo "<title>ADOdb Performance Monitor on $app</title><body bgcolor=white>";
        if ($do == 'viewsql') $form = "<td><form># SQL:<input type=hidden value=viewsql name=do> <input type=text size=4 name=nsql value=$nsql><input type=submit value=Go></td></form>";
        else $form = "<td>&nbsp;</td>";
        
        $allowsql = !defined('ADODB_PERF_NO_RUN_SQL');
        global $ADODB_PERF_MIN;
        $app .= " (Min sql timing \$ADODB_PERF_MIN=$ADODB_PERF_MIN secs)";
        
        if  (empty($_GET['hidem']))
        echo "<table border=1 width=100% bgcolor=lightyellow><tr><td colspan=2>
        <b><a href=http://adodb.sourceforge.net/?perf=1>ADOdb</a> Performance Monitor</b> <font size=1>for $app</font></tr><tr><td>
        <a href=?do=stats><b>Performance Stats</b></a> &nbsp; <a href=?do=viewsql><b>View SQL</b></a>
         &nbsp; <a href=?do=tables><b>View Tables</b></a> &nbsp; <a href=?do=poll><b>Poll Stats</b></a>",
         $allowsql ? ' &nbsp; <a href=?do=dosql><b>Run SQL</b></a>' : '',
         "$form",
         "</tr></table>";

         
                switch ($do) {
                default:
                case 'stats':
                        if (empty($ADODB_LOG_CONN))
                                echo "<p>&nbsp; <a href=\"?do=viewsql&clearsql=1\">Clear SQL Log</a><br>";
                        echo $this->HealthCheck();
                        //$this->conn->debug=1;
                        echo $this->CheckMemory();              
                        break;
                case 'poll':
                        $self = htmlspecialchars($_SERVER['PHP_SELF']);
                        echo "<iframe width=720 height=80% 
                                src=\"{$self}?do=poll2&hidem=1\"></iframe>";
                        break;
                case 'poll2':
                        echo "<pre>";
                        $this->Poll($pollsecs);
                        break;
                
                case 'dosql':
                        if (!$allowsql) break;
                        
                        $this->DoSQLForm();
                        break;
                case 'viewsql':
                        if (empty($_GET['hidem']))
                                echo "&nbsp; <a href=\"?do=viewsql&clearsql=1\">Clear SQL Log</a><br>";
                        echo($this->SuspiciousSQL($nsql));
                        echo($this->ExpensiveSQL($nsql));
                        echo($this->InvalidSQL($nsql));
                        break;
                case 'tables': 
                        echo $this->Tables(); break;
                }
                global $ADODB_vers;
                echo "<p><div align=center><font size=1>$ADODB_vers Sponsored by <a href=http://phplens.com/>phpLens</a></font></div>";
        }

undomq

(

$

m

)

Definiert in Zeile 998 der Datei adodb-perf.inc.php.

        {
        if (get_magic_quotes_gpc()) {
                // undo the damage
                $m = str_replace('\\\\','\\',$m);
                $m = str_replace('\"','"',$m);
                $m = str_replace('\\\'','\'',$m);
        }
        return $m;
}

WarnCacheRatio

(

$

val

)

Definiert in Zeile 656 der Datei adodb-perf.inc.php.

        {
                if ($val < $this->warnRatio) 
                         return '<font color=red><b>Cache ratio should be at least '.$this->warnRatio.'%</b></font>';
                else return '';
        }

---

Dokumentation der Datenelemente

$_lastLoad

Definiert in Zeile 351 der Datei adodb-perf.inc.php.

$cliFormat = "%32s => %s \r\n"

Definiert in Zeile 224 der Datei adodb-perf.inc.php.

$color = '#F0F0F0'

Definiert in Zeile 219 der Datei adodb-perf.inc.php.

$conn

Definiert in Zeile 218 der Datei adodb-perf.inc.php.

$createTableSQL = false

Erneute Implementation in perf_db2, perf_informix, perf_mssql, perf_mssqlnative, perf_mysql und perf_postgres.

Definiert in Zeile 228 der Datei adodb-perf.inc.php.

$explain = true

Definiert in Zeile 226 der Datei adodb-perf.inc.php.

$helpurl = "<a href=http://phplens.com/adodb/reference.functions.fnexecute.and.fncacheexecute.properties.html#logsql>LogSQL help</a>"

Definiert in Zeile 227 der Datei adodb-perf.inc.php.

$maxLength = 2000

Definiert in Zeile 229 der Datei adodb-perf.inc.php.

$sql1 = 'sql1'

Erneute Implementation in perf_mssql und perf_mssqlnative.

Definiert in Zeile 225 der Datei adodb-perf.inc.php.

$table = '<table border=1 bgcolor=white>'

Definiert in Zeile 220 der Datei adodb-perf.inc.php.

$tablesSQL = false

Erneute Implementation in perf_informix, perf_mysql und perf_postgres.

Definiert in Zeile 223 der Datei adodb-perf.inc.php.

$titles = '<tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr>'

Definiert in Zeile 221 der Datei adodb-perf.inc.php.

$warnRatio = 90

Definiert in Zeile 222 der Datei adodb-perf.inc.php.

---

Die Dokumentation für diese Klasse wurde erzeugt aufgrund der Datei:

• adodb-perf.inc.php