X-Git-Url: https://scripts.mit.edu/gitweb/autoinstalls/mediawiki.git/blobdiff_plain/c33ba33ef28344d64266b8b588460a301750fad5..83d871ca0d985c6d586b323bf96161afb510ebf6:/profileinfo.php diff --git a/profileinfo.php b/profileinfo.php index 4e2a3d76..83ae1935 100644 --- a/profileinfo.php +++ b/profileinfo.php @@ -1,247 +1,464 @@ - + + -Profiling data - + p, ul, ol, table { + margin: 0.5em 0; + } + + a { + color: #0645AD; + text-decoration: none; + } + + a:hover { + text-decoration: underline; + } + + /*! + * Bootstrap v2.1.1 + * + * Copyright 2012 Twitter, Inc + * Licensed under the Apache License v2.0 + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Designed and built with all the love in the world @twitter by @mdo and @fat. + */ + + table { + max-width: 100%; + background-color: transparent; + border-collapse: collapse; + border-spacing: 0; + } + + .table { + width: 100%; + margin-bottom: 20px; + } + + .table th, + .table td { + padding: 0.1em; + text-align: left; + vertical-align: top; + border-top: 1px solid #ddd; + } + + .table th { + font-weight: bold; + } + + .table thead th { + vertical-align: bottom; + } + + .table thead:first-child tr:first-child th, + .table thead:first-child tr:first-child td { + border-top: 0; + } + + .table tbody + tbody { + border-top: 2px solid #ddd; + } + + .table-condensed th, + .table-condensed td { + padding: 4px 5px; + } + + .table-striped tbody tr:nth-child(odd) td, + .table-striped tbody tr:nth-child(odd) th { + background-color: #f9f9f9; + } + + .table-hover tbody tr:hover td, + .table-hover tbody tr:hover th { + background-color: #f5f5f5; + } + + hr { + margin: 20px 0; + border: 0; + border-top: 1px solid #eee; + border-bottom: 1px solid #fff; + } + Disabled

' + . ''; + exit( 1 ); +} -define( 'MW_NO_SETUP', 1 ); -require_once( './includes/WebStart.php' ); -require_once("./AdminSettings.php"); +$dbr = wfGetDB( DB_REPLICA ); -if (!$wgEnableProfileInfo) { - echo "disabled\n"; +if ( !$dbr->tableExists( 'profiling' ) ) { + echo '

No profiling table exists, so we can\'t show you anything.

' + . '

If you want to log profiling data, enable $wgProfiler[\'output\'] = \'db\'' + . ' in your StartProfiler.php and run maintenance/update.php to' + . ' create the profiling table.' + . ''; exit( 1 ); } -foreach (array("wgDBadminuser", "wgDBadminpassword", "wgDBserver", "wgDBname") as $var) - if ($$var === false) { - echo "AdminSettings.php not correct\n"; - exit( 1 ); +$expand = []; +if ( isset( $_REQUEST['expand'] ) ) { + foreach ( explode( ',', $_REQUEST['expand'] ) as $f ) { + $expand[$f] = true; } +} +// @codingStandardsIgnoreStart +class profile_point { + // @codingStandardsIgnoreEnd -$expand = array(); -if (isset($_REQUEST['expand'])) - foreach(explode(",", $_REQUEST['expand']) as $f) - $expand[$f] = true; + public $name; + public $count; + public $time; + public $children; -class profile_point { - var $name; - var $count; - var $time; - var $children; + public static $totaltime, $totalmemory, $totalcount; - function profile_point($name, $count, $time) { + public function __construct( $name, $count, $time, $memory ) { $this->name = $name; $this->count = $count; $this->time = $time; - $this->children = array(); + $this->memory = $memory; + $this->children = []; } - function add_child($child) { + public function add_child( $child ) { $this->children[] = $child; } - function display($indent = 0.0) { - global $expand; - usort($this->children, "compare_point"); + public function display( $expand, $indent = 0.0 ) { + usort( $this->children, 'compare_point' ); - $extet = ''; - if (isset($expand[$this->name()])) - $ex = true; - else $ex = false; - if (!$ex) { - if (count($this->children)) { - $url = makeurl(false, false, $expand + array($this->name() => true)); - $extet = " [+]"; - } else $extet = ''; - } else { - $e = array(); - foreach ($expand as $name => $ep) - if ($name != $this->name()) - $e += array($name => $ep); + $ex = isset( $expand[$this->name()] ); + + $anchor = str_replace( '"', '', $this->name() ); - $extet = " [–]"; + if ( !$ex ) { + if ( count( $this->children ) ) { + $url = getEscapedProfileUrl( false, false, $expand + [ $this->name() => true ] ); + $extet = " [+]"; + } else { + $extet = ''; + } + } else { + $e = []; + foreach ( $expand as $name => $ep ) { + if ( $name != $this->name() ) { + $e += [ $name => $ep ]; + } + } + $url = getEscapedProfileUrl( false, false, $e ); + $extet = " [–]"; } ?> - - fmttime() ?> - count() ?> - - name()) . $extet ?> - - + + +

+ name() ) ) . $extet ?> +
+ + + time() / self::$totaltime * 100 ); ?> + memory() / self::$totalmemory * 100 ); ?> + count(); ?> + callsPerRequest() ), 2 ); ?> + timePerCall() ), 2 ); ?> + memoryPerCall() / 1024 ), 2 ); ?> + time() / self::$totalcount ), 2 ); ?> + memory() / self::$totalcount / 1024 ), 2 ); ?> + + children as $child) - $child->display($indent + 2); + if ( $ex ) { + foreach ( $this->children as $child ) { + $child->display( $expand, $indent + 2 ); + } + } } - function name() { + public function name() { return $this->name; } - function count() { + public function count() { return $this->count; } - function time() { + public function time() { return $this->time; } - function fmttime() { - return sprintf("%5.02f", $this->time); + public function memory() { + return $this->memory; + } + + public function timePerCall() { + // @codingStandardsIgnoreStart + return @( $this->time / $this->count ); + // @codingStandardsIgnoreEnd + } + + public function memoryPerCall() { + // @codingStandardsIgnoreStart + return @( $this->memory / $this->count ); + // @codingStandardsIgnoreEnd + } + + public function callsPerRequest() { + // @codingStandardsIgnoreStart + return @( $this->count / self::$totalcount ); + // @codingStandardsIgnoreEnd + } + + public function timePerRequest() { + // @codingStandardsIgnoreStart + return @( $this->time / self::$totalcount ); + // @codingStandardsIgnoreEnd + } + + public function memoryPerRequest() { + // @codingStandardsIgnoreStart + return @( $this->memory / self::$totalcount ); + // @codingStandardsIgnoreEnd + } + + public function fmttime() { + return sprintf( '%5.02f', $this->time ); } }; -function compare_point($a, $b) { +function compare_point( profile_point $a, profile_point $b ) { + // @codingStandardsIgnoreStart global $sort; - switch ($sort) { - case "name": - return strcmp($a->name(), $b->name()); - case "time": - return $a->time() > $b->time() ? -1 : 1; - case "count": - return $a->count() > $b->count() ? -1 : 1; + // @codingStandardsIgnoreEnd + switch ( $sort ) { + case 'name': + return strcmp( $a->name(), $b->name() ); + case 'time': + return $a->time() > $b->time() ? -1 : 1; + case 'memory': + return $a->memory() > $b->memory() ? -1 : 1; + case 'count': + return $a->count() > $b->count() ? -1 : 1; + case 'time_per_call': + return $a->timePerCall() > $b->timePerCall() ? -1 : 1; + case 'memory_per_call': + return $a->memoryPerCall() > $b->memoryPerCall() ? -1 : 1; + case 'calls_per_req': + return $a->callsPerRequest() > $b->callsPerRequest() ? -1 : 1; + case 'time_per_req': + return $a->timePerRequest() > $b->timePerRequest() ? -1 : 1; + case 'memory_per_req': + return $a->memoryPerRequest() > $b->memoryPerRequest() ? -1 : 1; } } -$sorts = array("time", "count", "name"); +$sorts = [ 'time', 'memory', 'count', 'calls_per_req', 'name', + 'time_per_call', 'memory_per_call', 'time_per_req', 'memory_per_req' ]; $sort = 'time'; -if (isset($_REQUEST['sort']) && in_array($_REQUEST['sort'], $sorts)) +if ( isset( $_REQUEST['sort'] ) && in_array( $_REQUEST['sort'], $sorts ) ) { $sort = $_REQUEST['sort']; +} -$dbh = mysql_connect($wgDBserver, $wgDBadminuser, $wgDBadminpassword) - or die("mysql server failed: " . mysql_error()); -mysql_select_db($wgDBname, $dbh) or die(mysql_error($dbh)); -$res = mysql_query(" - SELECT pf_count, pf_time, pf_name - FROM profiling - ORDER BY pf_name ASC -", $dbh) or die("query failed: " . mysql_error()); +$res = $dbr->select( + 'profiling', + '*', + [], + 'profileinfo.php', + [ 'ORDER BY' => 'pf_name ASC' ] +); -if (isset($_REQUEST['filter'])) +if ( isset( $_REQUEST['filter'] ) ) { $filter = $_REQUEST['filter']; -else $filter = ''; +} else { + $filter = ''; +} ?> -
-

- - -"/> - -

+ +

+ + + "> + +

- - - - - - - + + + + + + + + + + + + + + + $_filter ? $_filter : $filter, + 'sort' => $_sort ? $_sort : $sort, + 'expand' => implode( ',', array_keys( $_expand ) ) + ] ) + ); + } -$points = array(); -$queries = array(); -$sqltotal = 0.0; - -$last = false; -while (($o = mysql_fetch_object($res)) !== false) { - $next = new profile_point($o->pf_name, $o->pf_count, $o->pf_time); - $totaltime += $next->time(); - if ($last !== false) { - if (preg_match("/^".preg_quote($last->name(), "/")."/", $next->name())) { - $last->add_child($next); - continue; + $points = []; + $queries = []; + $sqltotal = 0.0; + + $last = false; + foreach ( $res as $o ) { + $next = new profile_point( $o->pf_name, $o->pf_count, $o->pf_time, $o->pf_memory ); + if ( $next->name() == '-total' || $next->name() == 'main()' ) { + profile_point::$totaltime = $next->time(); + profile_point::$totalcount = $next->count(); + profile_point::$totalmemory = $next->memory(); + } + if ( $last !== false ) { + if ( preg_match( '/^' . preg_quote( $last->name(), '/' ) . '/', $next->name() ) ) { + $last->add_child( $next ); + continue; + } + } + $last = $next; + if ( preg_match( '/^query: /', $next->name() ) || preg_match( '/^query-m: /', $next->name() ) ) { + $sqltotal += $next->time(); + $queries[] = $next; + } else { + $points[] = $next; } } - $last = $next; - if (preg_match("/^query: /", $next->name())) { - $sqltotal += $next->time(); - $queries[] = $next; - } else { - $points[] = $next; - } -} -$s = new profile_point("SQL Queries", 0, $sqltotal); -foreach ($queries as $q) - $s->add_child($q); -$points[] = $s; + $s = new profile_point( 'SQL Queries', 0, $sqltotal, 0, 0 ); + foreach ( $queries as $q ) { + $s->add_child( $q ); + } + $points[] = $s; -usort($points, "compare_point"); + // @codingStandardsIgnoreStart + @usort( $points, 'compare_point' ); + // @codingStandardsIgnoreEnd -foreach ($points as $point) { - if (strlen($filter) && !strstr($point->name(), $filter)) - continue; + foreach ( $points as $point ) { + if ( strlen( $filter ) && !strstr( $point->name(), $filter ) ) { + continue; + } - $point->display(); -} -?> + $point->display( $expand ); + } + ?> +
">Time">Count">Name
NameTime (%)Memory (%)CountCalls/reqms/callkb/callms/reqkb/req
+
+

Total time:

-

Total time:

- +

Total memory:

+