1.28.0/php/profileinfo_8php_source.html

 <?php

 // This endpoint is supposed to be independent of request cookies and other

 // details of the session. Log warnings for violations of the no-session

 // constraint.

 define( 'MW_NO_SESSION', 'warn' );


 ini_set( 'zlib.output_compression', 'off' );


 $wgEnableProfileInfo = false;

 require __DIR__ . '/includes/WebStart.php';


 header( 'Content-Type: text/html; charset=utf-8' );


 ?>

 <!DOCTYPE html>

 <html>

 <head>

     <meta charset="UTF-8" />

     <title>Profiling data</title>

     <style>

         /* noc.wikimedia.org/base.css */


         * {

             margin: 0;

             padding: 0;

         }


         body {

             padding: 0.5em 1em;

             background: #fff;

             font: 14px/1.6 sans-serif;

             color: #333;

         }


         p, ul, ol, table {

             margin: 0.5em 0;

         }


         a {

             color: #0645AD;

             text-decoration: none;

         }


         a:hover {

             text-decoration: underline;

         }


         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;

         }

     </style>

 </head>

 <body>

 <?php


 if ( !$wgEnableProfileInfo ) {

     echo '<p>Disabled</p>'

         . '</body></html>';

     exit( 1 );

 }


 $dbr = wfGetDB( DB_SLAVE );


 if ( !$dbr->tableExists( 'profiling' ) ) {

     echo '<p>No <code>profiling</code> table exists, so we can\'t show you anything.</p>'

         . '<p>If you want to log profiling data, enable <code>$wgProfiler[\'output\'] = \'db\'</code>'

         . ' in your StartProfiler.php and run <code>maintenance/update.php</code> to'

         . ' create the profiling table.'

         . '</body></html>';

     exit( 1 );

 }


 $expand = [];

 if ( isset( $_REQUEST['expand'] ) ) {

     foreach ( explode( ',', $_REQUEST['expand'] ) as $f ) {

         $expand[$f] = true;

     }

 }


 // @codingStandardsIgnoreStart

 class profile_point {

     // @codingStandardsIgnoreEnd


     public $name;

     public $count;

     public $time;

     public $children;


     public static $totaltime, $totalmemory, $totalcount;


     public function __construct( $name, $count, $time, $memory ) {

         $this->name = $name;

         $this->count = $count;

         $this->time = $time;

         $this->memory = $memory;

         $this->children = [];

     }


     public function add_child( $child ) {

         $this->children[] = $child;

     }


     public function display( $expand, $indent = 0.0 ) {

         usort( $this->children, 'compare_point' );


         $ex = isset( $expand[$this->name()] );


         $anchor = str_replace( '"', '', $this->name() );


         if ( !$ex ) {

             if ( count( $this->children ) ) {

                 $url = getEscapedProfileUrl( false, false, $expand + [ $this->name() => true ] );

                 $extet = " <a id=\"{$anchor}\" href=\"{$url}#{$anchor}\">[+]</a>";

             } else {

                 $extet = '';

             }

         } else {

             $e = [];

             foreach ( $expand as $name => $ep ) {

                 if ( $name != $this->name() ) {

                     $e += [ $name => $ep ];

                 }

             }

             $url = getEscapedProfileUrl( false, false, $e );

             $extet = " <a id=\"{$anchor}\" href=\"{$url}#{$anchor}\">[–]</a>";

         }

         ?>

     <tr>

         <th>

             <div style="margin-left: <?php echo (int)$indent; ?>em;">

                 <?php echo htmlspecialchars( str_replace( ',', ', ', $this->name() ) ) . $extet ?>

             </div>

         </th>

         <?php //@codingStandardsIgnoreStart ?>

         <td class="mw-profileinfo-timep"><?php echo @wfPercent( $this->time() / self::$totaltime * 100 ); ?></td>

         <td class="mw-profileinfo-memoryp"><?php echo @wfPercent( $this->memory() / self::$totalmemory * 100 ); ?></td>

         <td class="mw-profileinfo-count"><?php echo $this->count(); ?></td>

         <td class="mw-profileinfo-cpr"><?php echo round( sprintf( '%.2f', $this->callsPerRequest() ), 2 ); ?></td>

         <td class="mw-profileinfo-tpc"><?php echo round( sprintf( '%.2f', $this->timePerCall() ), 2 ); ?></td>

         <td class="mw-profileinfo-mpc"><?php echo round( sprintf( '%.2f', $this->memoryPerCall() / 1024 ), 2 ); ?></td>

         <td class="mw-profileinfo-tpr"><?php echo @round( sprintf( '%.2f', $this->time() / self::$totalcount ), 2 ); ?></td>

         <td class="mw-profileinfo-mpr"><?php echo @round( sprintf( '%.2f', $this->memory() / self::$totalcount / 1024 ), 2 ); ?></td>

         <?php //@codingStandardsIgnoreEnd ?>

     </tr>

         <?php

         if ( $ex ) {

             foreach ( $this->children as $child ) {

                 $child->display( $expand, $indent + 2 );

             }

         }

     }


     public function name() {

         return $this->name;

     }


     public function count() {

         return $this->count;

     }


     public function time() {

         return $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( profile_point $a, profile_point $b ) {

     // @codingStandardsIgnoreStart

     global $sort;

     // @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 = [ '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 ) ) {

     $sort = $_REQUEST['sort'];

 }


 $res = $dbr->select(

     'profiling',

     '*',

     [],

     'profileinfo.php',

     [ 'ORDER BY' => 'pf_name ASC' ]

 );


 if ( isset( $_REQUEST['filter'] ) ) {

     $filter = $_REQUEST['filter'];

 } else {

     $filter = '';

 }


 ?>

 <form method="get" action="profileinfo.php">

     <p>

         <input type="text" name="filter" value="<?php echo htmlspecialchars( $filter ); ?>">

         <input type="hidden" name="sort" value="<?php echo htmlspecialchars( $sort ); ?>">

         <input type="hidden" name="expand" value="<?php

             echo htmlspecialchars( implode( ",", array_keys( $expand ) ) );

         ?>">

         <input type="submit" value="Filter">

     </p>

 </form>


 <table class="mw-profileinfo-table table table-striped table-hover">

     <thead>

     <tr>

         <th><a href="<?php

             echo getEscapedProfileUrl( false, 'name' );

         ?>">Name</a></th>

         <th><a href="<?php

             echo getEscapedProfileUrl( false, 'time' );

         ?>">Time (%)</a></th>

         <th><a href="<?php

             echo getEscapedProfileUrl( false, 'memory' );

         ?>">Memory (%)</a></th>

         <th><a href="<?php

             echo getEscapedProfileUrl( false, 'count' );

         ?>">Count</a></th>

         <th><a href="<?php

             echo getEscapedProfileUrl( false, 'calls_per_req' );

         ?>">Calls/req</a></th>

         <th><a href="<?php

             echo getEscapedProfileUrl( false, 'time_per_call' );

         ?>">ms/call</a></th>

         <th><a href="<?php

             echo getEscapedProfileUrl( false, 'memory_per_call' );

         ?>">kb/call</a></th>

         <th><a href="<?php

             echo getEscapedProfileUrl( false, 'time_per_req' );

         ?>">ms/req</a></th>

         <th><a href="<?php

             echo getEscapedProfileUrl( false, 'memory_per_req' );

         ?>">kb/req</a></th>

     </tr>

     </thead>

     <tbody>

     <?php

     profile_point::$totaltime = 0.0;

     profile_point::$totalcount = 0;

     profile_point::$totalmemory = 0.0;


     function getEscapedProfileUrl( $_filter = false, $_sort = false, $_expand = false ) {

         // @codingStandardsIgnoreStart

         global $filter, $sort, $expand;

         // @codingStandardsIgnoreEnd


         if ( $_expand === false ) {

             $_expand = $expand;

         }


         return htmlspecialchars(

             '?' .

                 wfArrayToCgi( [

                     'filter' => $_filter ? $_filter : $filter,

                     'sort' => $_sort ? $_sort : $sort,

                     'expand' => implode( ',', array_keys( $_expand ) )

                 ] )

         );

     }


     $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;

         }

     }


     $s = new profile_point( 'SQL Queries', 0, $sqltotal, 0, 0 );

     foreach ( $queries as $q ) {

         $s->add_child( $q );

     }

     $points[] = $s;


     // @codingStandardsIgnoreStart

     @usort( $points, 'compare_point' );

     // @codingStandardsIgnoreEnd


     foreach ( $points as $point ) {

         if ( strlen( $filter ) && !strstr( $point->name(), $filter ) ) {

             continue;

         }


         $point->display( $expand );

     }

     ?>

     </tbody>

 </table>

 <hr />

 <p>Total time: <code><?php printf( '%5.02f', profile_point::$totaltime ); ?></code></p>


 <p>Total memory: <code><?php printf( '%5.02f', profile_point::$totalmemory / 1024 ); ?></code></p>

 <hr />

 </body>

 </html>

data
and how to run hooks for an and one after Each event has a preferably in CamelCase For ArticleDelete hook A clump of code and data that should be run when an event happens This can be either a function and a chunk of data
Definition: hooks.txt:6

form
null means default in associative array form
Definition: hooks.txt:1936

profile_point\name
name()
Definition: profileinfo.php:244

wfGetDB
wfGetDB($db, $groups=[], $wiki=false)
Get a Database object.
Definition: GlobalFunctions.php:3073

$s
foreach($res as $o) $s
Definition: profileinfo.php:438

wfPercent
wfPercent($nr, $acc=2, $round=true)
Definition: GlobalFunctions.php:2161

profile_point\fmttime
fmttime()
Definition: profileinfo.php:290

profile_point\timePerRequest
timePerRequest()
Definition: profileinfo.php:278

profile_point\memoryPerCall
memoryPerCall()
Definition: profileinfo.php:266

$e
div flags Integer display flags(NO_ACTION_LINK, NO_EXTRA_USER_LINKS) 'LogException'returning false will NOT prevent logging $e
Definition: hooks.txt:2102

profile_point\callsPerRequest
callsPerRequest()
Definition: profileinfo.php:272

width
width
Definition: parserTests.txt:155

$sort
$sort
Definition: profileinfo.php:323

profile_point\timePerCall
timePerCall()
Definition: profileinfo.php:260

profile_point\time
time()
Definition: profileinfo.php:252

global
when a variable name is used in a it is silently declared as a new local masking the global
Definition: design.txt:93

title
title
Definition: parserTests.txt:211

profile_point\display
display($expand, $indent=0.0)
Definition: profileinfo.php:194

$last
$last
Definition: profileinfo.php:415

profile_point\$count
$count
Definition: profileinfo.php:176

style
Bar style
Definition: parserTests.txt:184

profile_point\count
count()
Definition: profileinfo.php:248

$points
$points
Definition: profileinfo.php:411

profile_point\memory
memory()
Definition: profileinfo.php:256

$expand
if(!$dbr->tableExists( 'profiling')) $expand
Definition: profileinfo.php:164

$sorts
$sorts
Definition: profileinfo.php:321

profile_point\$totalmemory
static $totalmemory
Definition: profileinfo.php:180

$sqltotal
$sqltotal
Definition: profileinfo.php:413

$res
if(isset($_REQUEST['sort'])&&in_array($_REQUEST['sort'], $sorts)) $res
Definition: profileinfo.php:328

text
design txt This is a brief overview of the new design More thorough and up to date information is available on the documentation wiki at etc Handles the details of getting and saving to the user table of the and dealing with sessions and cookies OutputPage Encapsulates the entire HTML page that will be sent in response to any server request It is used by calling its functions to add text
Definition: design.txt:12

memory
MediaWiki has optional support for a high distributed memory object caching system For general information on but for a larger site with heavy like it should help lighten the load on the database servers by caching data and objects in memory
Definition: memcached.txt:10

profile_point\__construct
__construct($name, $count, $time, $memory)
Definition: profileinfo.php:182

as
This document is intended to provide useful advice for parties seeking to redistribute MediaWiki to end users It s targeted particularly at maintainers for Linux since it s been observed that distribution packages of MediaWiki often break We ve consistently had to recommend that users seeking support use official tarballs instead of their distribution s and this often solves whatever problem the user is having It would be nice if this could such as
Definition: distributors.txt:9

f9f9f9
f9f9f9
Definition: parserTests.txt:149

profile_point\$totalcount
static $totalcount
Definition: profileinfo.php:180

color
in the sidebar</td >< td > font color
Definition: All_system_messages.txt:425

getEscapedProfileUrl
getEscapedProfileUrl($_filter=false, $_sort=false, $_expand=false)
Definition: profileinfo.php:392

$dbr
if(!$wgEnableProfileInfo) $dbr
Definition: profileinfo.php:153

php
injection txt This is an overview of how MediaWiki makes use of dependency injection The design described here grew from the discussion of RFC T384 The term dependency this means that anything an object needs to operate should be injected from the the object itself should only know narrow no concrete implementation of the logic it relies on The requirement to inject everything typically results in an architecture that based on two main types of and essentially stateless service objects that use other service objects to operate on the value objects As of the beginning MediaWiki is only starting to use the DI approach Much of the code still relies on global state or direct resulting in a highly cyclical dependency which acts as the top level factory for services in MediaWiki which can be used to gain access to default instances of various services MediaWikiServices however also allows new services to be defined and default services to be redefined Services are defined or redefined by providing a callback the instantiator that will return a new instance of the service When it will create an instance of MediaWikiServices and populate it with the services defined in the files listed by thereby bootstrapping the DI framework Per $wgServiceWiringFiles lists includes ServiceWiring php
Definition: injection.txt:35

profile_point\$name
$name
Definition: profileinfo.php:175

profile_point\$totaltime
static $totaltime
Definition: profileinfo.php:180

code
and how to run hooks for an and one after Each event has a preferably in CamelCase For ArticleDelete hook A clump of code and data that should be run when an event happens This can be either a function and a chunk of or an object and a method hook function The function part of a third party developers and local administrators to define code that will be run at certain points in the mainline code
Definition: hooks.txt:23

profile_point\memoryPerRequest
memoryPerRequest()
Definition: profileinfo.php:284

wfArrayToCgi
wfArrayToCgi($array1, $array2=null, $prefix= '')
This function takes one or two arrays as input, and returns a CGI-style string, e.g.
Definition: GlobalFunctions.php:406

name
design txt This is a brief overview of the new design More thorough and up to date information is available on the documentation wiki at name
Definition: design.txt:12

profile_point\$children
$children
Definition: profileinfo.php:178

compare_point
compare_point(profile_point $a, profile_point $b)
Definition: profileinfo.php:295

profile_point\add_child
add_child($child)
Definition: profileinfo.php:190

profile_point
Definition: profileinfo.php:172

$queries
$queries
Definition: profileinfo.php:412

DB_SLAVE
const DB_SLAVE
Definition: Defines.php:28

$wgEnableProfileInfo
$wgEnableProfileInfo
Definition: profileinfo.php:35

profile_point\$time
$time
Definition: profileinfo.php:177