lag.php

Go to the documentation of this file.

<?php
require_once __DIR__ . '/Maintenance.php';
 
use MediaWiki\MediaWikiServices;
 
class DatabaseLag extends Maintenance {
    public function __construct() {
        parent::__construct();
        $this->addDescription( 'Shows database lag' );
        $this->addOption( 'r', "Don't exit immediately, but show the lag every 5 seconds" );
    }
 
    public function execute() {
        $lb = MediaWikiServices::getInstance()->getDBLoadBalancer();
        if ( $this->hasOption( 'r' ) ) {
            echo 'time     ';
 
            $serverCount = $lb->getServerCount();
            for ( $i = 1; $i < $serverCount; $i++ ) {
                $hostname = $lb->getServerName( $i );
                printf( "%-12s ", $hostname );
            }
            echo "\n";
 
            while ( 1 ) {
                $lags = $lb->getLagTimes();
                unset( $lags[0] );
                echo gmdate( 'H:i:s' ) . ' ';
                foreach ( $lags as $lag ) {
                    printf( "%-12s ", $lag === false ? 'false' : $lag );
                }
                echo "\n";
                sleep( 5 );
            }
        } else {
            $lags = $lb->getLagTimes();
            foreach ( $lags as $i => $lag ) {
                $name = $lb->getServerName( $i );
                $this->output( sprintf( "%-20s %s\n", $name, $lag === false ? 'false' : $lag ) );
            }
        }
    }
}
 
$maintClass = DatabaseLag::class;
require_once RUN_MAINTENANCE_IF_MAIN;