ProfilerSimpleDB.php

Go to the documentation of this file.

<?php
class ProfilerSimpleDB extends ProfilerStandard {
    protected function collateOnly() {
        return true;
    }

    public function isPersistent() {
        return true;
    }

    public function logData() {
        global $wgProfilePerHost;

        # Do not log anything if database is readonly (bug 5375)
        if ( wfReadOnly() ) {
            return;
        }

        if ( $wgProfilePerHost ) {
            $pfhost = wfHostname();
        } else {
            $pfhost = '';
        }

        try {
            $this->collateData();

            $dbw = wfGetDB( DB_MASTER );
            $useTrx = ( $dbw->getType() === 'sqlite' ); // much faster
            if ( $useTrx ) {
                $dbw->startAtomic( __METHOD__ );
            }
            foreach ( $this->mCollated as $name => $data ) {
                $eventCount = $data['count'];
                $timeSum = (float)( $data['real'] * 1000 );
                $memorySum = (float)$data['memory'];
                $name = substr( $name, 0, 255 );

                // Kludge
                $timeSum = $timeSum >= 0 ? $timeSum : 0;
                $memorySum = $memorySum >= 0 ? $memorySum : 0;

                $dbw->update( 'profiling',
                    array(
                        "pf_count=pf_count+{$eventCount}",
                        "pf_time=pf_time+{$timeSum}",
                        "pf_memory=pf_memory+{$memorySum}",
                    ),
                    array(
                        'pf_name' => $name,
                        'pf_server' => $pfhost,
                    ),
                    __METHOD__ );

                $rc = $dbw->affectedRows();
                if ( $rc == 0 ) {
                    $dbw->insert( 'profiling',
                        array(
                            'pf_name' => $name,
                            'pf_count' => $eventCount,
                            'pf_time' => $timeSum,
                            'pf_memory' => $memorySum,
                            'pf_server' => $pfhost
                        ),
                        __METHOD__,
                        array( 'IGNORE' )
                    );
                }
                // When we upgrade to mysql 4.1, the insert+update
                // can be merged into just a insert with this construct added:
                //     "ON DUPLICATE KEY UPDATE ".
                //     "pf_count=pf_count + VALUES(pf_count), ".
                //     "pf_time=pf_time + VALUES(pf_time)";
            }
            if ( $useTrx ) {
                $dbw->endAtomic( __METHOD__ );
            }
        } catch ( DBError $e ) {
        }
    }
}