REL1_31/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_REPLICA );


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;

    }

}


// phpcs:ignore Squiz.Classes.ValidClassName.NotCamelCaps


class profile_point {


    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 // phpcs:disable Generic.Files.LineLength,Generic.PHP.NoSilencedErrors ?>

        <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 // phpcs:enable ?>

    </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() {

        // phpcs:ignore Generic.PHP.NoSilencedErrors.Discouraged

        return @( $this->time / $this->count );

    }


    public function memoryPerCall() {

        // phpcs:ignore Generic.PHP.NoSilencedErrors.Discouraged

        return @( $this->memory / $this->count );

    }


    public function callsPerRequest() {

        // phpcs:ignore Generic.PHP.NoSilencedErrors.Discouraged

        return @( $this->count / self::$totalcount );

    }


    public function timePerRequest() {

        // phpcs:ignore Generic.PHP.NoSilencedErrors.Discouraged

        return @( $this->time / self::$totalcount );

    }


    public function memoryPerRequest() {

        // phpcs:ignore Generic.PHP.NoSilencedErrors.Discouraged

        return @( $this->memory / self::$totalcount );

    }


    public function fmttime() {

        return sprintf( '%5.02f', $this->time );

    }


};


function compare_point( profile_point $a, profile_point $b ) {

    // phpcs:ignore MediaWiki.NamingConventions.ValidGlobalName.wgPrefix

    global $sort;


    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 ) {

        // phpcs:ignore MediaWiki.NamingConventions.ValidGlobalName.wgPrefix

        global $filter, $sort, $expand;


        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;


    // phpcs:ignore Generic.PHP.NoSilencedErrors.Discouraged

    @usort( $points, 'compare_point' );


    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>

href
shown</td >< td > a href
Definition All_system_messages.txt:2667

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

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

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

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

profile_point
Definition profileinfo.php:172

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

table
deferred txt A few of the database updates required by various functions here can be deferred until after the result page is displayed to the user For updating the view updating the linked to tables after a etc PHP does not yet have any way to tell the server to actually return and disconnect while still running these but it might have such a feature in the future We handle these by creating a deferred update object and putting those objects on a global then executing the whole list after the page is displayed We don t do anything smart like collating updates to the same table or such because the list is almost always going to have just one item on if so it s not worth the trouble Since there is a job queue in the jobs table
Definition deferred.txt:16

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

name
> value, names are case insensitive). Two headers get special handling:If-Modified-Since(value must be a valid HTTP date) and Range(must be of the form "bytes=(\d*-\d*)") will be honored when streaming the file. 'ImportHandleLogItemXMLTag':When parsing a XML tag in a log item. Return false to stop further processing of the tag $reader:XMLReader object $logInfo:Array of information 'ImportHandlePageXMLTag':When parsing a XML tag in a page. Return false to stop further processing of the tag $reader:XMLReader object & $pageInfo:Array of information 'ImportHandleRevisionXMLTag':When parsing a XML tag in a page revision. Return false to stop further processing of the tag $reader:XMLReader object $pageInfo:Array of page information $revisionInfo:Array of revision information 'ImportHandleToplevelXMLTag':When parsing a top level XML tag. Return false to stop further processing of the tag $reader:XMLReader object 'ImportHandleUnknownUser':When a user doesn 't exist locally, this hook is called to give extensions an opportunity to auto-create it. If the auto-creation is successful, return false. $name:User name 'ImportHandleUploadXMLTag':When parsing a XML tag in a file upload. Return false to stop further processing of the tag $reader:XMLReader object $revisionInfo:Array of information 'ImportLogInterwikiLink':Hook to change the interwiki link used in log entries and edit summaries for transwiki imports. & $fullInterwikiPrefix:Interwiki prefix, may contain colons. & $pageTitle:String that contains page title. 'ImportSources':Called when reading from the $wgImportSources configuration variable. Can be used to lazy-load the import sources list. & $importSources:The value of $wgImportSources. Modify as necessary. See the comment in DefaultSettings.php for the detail of how to structure this array. 'InfoAction':When building information to display on the action=info page. $context:IContextSource object & $pageInfo:Array of information 'InitializeArticleMaybeRedirect':MediaWiki check to see if title is a redirect. & $title:Title object for the current page & $request:WebRequest & $ignoreRedirect:boolean to skip redirect check & $target:Title/string of redirect target & $article:Article object 'InternalParseBeforeLinks':during Parser 's internalParse method before links but after nowiki/noinclude/includeonly/onlyinclude and other processings. & $parser:Parser object & $text:string containing partially parsed text & $stripState:Parser 's internal StripState object 'InternalParseBeforeSanitize':during Parser 's internalParse method just before the parser removes unwanted/dangerous HTML tags and after nowiki/noinclude/includeonly/onlyinclude and other processings. Ideal for syntax-extensions after template/parser function execution which respect nowiki and HTML-comments. & $parser:Parser object & $text:string containing partially parsed text & $stripState:Parser 's internal StripState object 'InterwikiLoadPrefix':When resolving if a given prefix is an interwiki or not. Return true without providing an interwiki to continue interwiki search. $prefix:interwiki prefix we are looking for. & $iwData:output array describing the interwiki with keys iw_url, iw_local, iw_trans and optionally iw_api and iw_wikiid. 'InvalidateEmailComplete':Called after a user 's email has been invalidated successfully. $user:user(object) whose email is being invalidated 'IRCLineURL':When constructing the URL to use in an IRC notification. Callee may modify $url and $query, URL will be constructed as $url . $query & $url:URL to index.php & $query:Query string $rc:RecentChange object that triggered url generation 'IsFileCacheable':Override the result of Article::isFileCacheable()(if true) & $article:article(object) being checked 'IsTrustedProxy':Override the result of IP::isTrustedProxy() & $ip:IP being check & $result:Change this value to override the result of IP::isTrustedProxy() 'IsUploadAllowedFromUrl':Override the result of UploadFromUrl::isAllowedUrl() $url:URL used to upload from & $allowed:Boolean indicating if uploading is allowed for given URL 'isValidEmailAddr':Override the result of Sanitizer::validateEmail(), for instance to return false if the domain name doesn 't match your organization. $addr:The e-mail address entered by the user & $result:Set this and return false to override the internal checks 'isValidPassword':Override the result of User::isValidPassword() $password:The password entered by the user & $result:Set this and return false to override the internal checks $user:User the password is being validated for 'Language::getMessagesFileName':$code:The language code or the language we 're looking for a messages file for & $file:The messages file path, you can override this to change the location. 'LanguageGetMagic':DEPRECATED! Use $magicWords in a file listed in $wgExtensionMessagesFiles instead. Use this to define synonyms of magic words depending of the language & $magicExtensions:associative array of magic words synonyms $lang:language code(string) 'LanguageGetNamespaces':Provide custom ordering for namespaces or remove namespaces. Do not use this hook to add namespaces. Use CanonicalNamespaces for that. & $namespaces:Array of namespaces indexed by their numbers 'LanguageGetSpecialPageAliases':DEPRECATED! Use $specialPageAliases in a file listed in $wgExtensionMessagesFiles instead. Use to define aliases of special pages names depending of the language & $specialPageAliases:associative array of magic words synonyms $lang:language code(string) 'LanguageGetTranslatedLanguageNames':Provide translated language names. & $names:array of language code=> language name $code:language of the preferred translations 'LanguageLinks':Manipulate a page 's language links. This is called in various places to allow extensions to define the effective language links for a page. $title:The page 's Title. & $links:Array with elements of the form "language:title" in the order that they will be output. & $linkFlags:Associative array mapping prefixed links to arrays of flags. Currently unused, but planned to provide support for marking individual language links in the UI, e.g. for featured articles. 'LanguageSelector':Hook to change the language selector available on a page. $out:The output page. $cssClassName:CSS class name of the language selector. 'LinkBegin':DEPRECATED! Use HtmlPageLinkRendererBegin instead. Used when generating internal and interwiki links in Linker::link(), before processing starts. Return false to skip default processing and return $ret. See documentation for Linker::link() for details on the expected meanings of parameters. $skin:the Skin object $target:the Title that the link is pointing to & $html:the contents that the< a > tag should have(raw HTML) name
Definition hooks.txt:1840

$e
returning false will NOT prevent logging $e
Definition hooks.txt:2176

a
</source > ! result< div class="mw-highlight mw-content-ltr" dir="ltr">< pre >< span ></span >< span class="kd"> var</span >< span class="nx"> a</span >< span class="p"></span ></pre ></div > !end !test Multiline< source/> in lists !input *< source > a b</source > *foo< source > a b</source > ! html< ul >< li >< div class="mw-highlight mw-content-ltr" dir="ltr">< pre > a b</pre ></div ></li ></ul >< ul >< li > foo< div class="mw-highlight mw-content-ltr" dir="ltr">< pre > a b</pre ></div ></li ></ul > !html tidy< ul >< li >< div class="mw-highlight mw-content-ltr" dir="ltr">< pre > a b</pre ></div ></li ></ul >< ul >< li > foo< div class="mw-highlight mw-content-ltr" dir="ltr">< pre > a b</pre ></div ></li ></ul > !end !test Custom attributes !input< source lang="javascript" id="foo" class="bar" dir="rtl" style="font-size: larger;"> var a
Definition parserTests.txt:118

none
</source > ! result< p > Text< code class="mw-highlight" dir="ltr">< span class="kd"> var</span >< span class="nx"> a</span >< span class="p"></span ></code ></p > !end !test Enclose none(inline code) !!input Text< source lang

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

captcha-old.font
font
Definition captcha-old.py:244

type
This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres but without copying over all the usage comments General notes on the but these can almost always be programmed around *Although Postgres has a true BOOLEAN type
Definition postgres.txt:30

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

$points
$points
Definition profileinfo.php:404

$wgEnableProfileInfo
$wgEnableProfileInfo
Definition profileinfo.php:35

$queries
$queries
Definition profileinfo.php:405

$sort
$sort
Definition profileinfo.php:317

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

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

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

$sorts
$sorts
Definition profileinfo.php:315

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

$last
$last
Definition profileinfo.php:408

$sqltotal
$sqltotal
Definition profileinfo.php:406

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

DB_REPLICA
const DB_REPLICA
Definition defines.php:25

div
div
Definition parserTests.txt:6593

f9f9f9
f9f9f9
Definition parserTests.txt:157

style
Bar style
Definition parserTests.txt:192

width
width
Definition parserTests.txt:163