MediaWiki  master
orphanStats.php
Go to the documentation of this file.
1 <?php
24 require_once __DIR__ . '/../Maintenance.php';
25 
32 class OrphanStats extends Maintenance {
33  public function __construct() {
34  parent::__construct();
35  $this->addDescription(
36  "Show some statistics on the blob_orphans table, created with trackBlobs.php" );
37  }
38 
39  protected function getExternalDB( $db, $cluster ) {
40  $lbFactory = $this->getServiceContainer()->getDBLoadBalancerFactory();
41  $lb = $lbFactory->getExternalLB( $cluster );
42 
43  return $lb->getMaintenanceConnectionRef( $db );
44  }
45 
46  public function execute() {
47  $dbr = $this->getDB( DB_REPLICA );
48  if ( !$dbr->tableExists( 'blob_orphans', __METHOD__ ) ) {
49  $this->fatalError( "blob_orphans doesn't seem to exist, need to run trackBlobs.php first" );
50  }
51  $res = $dbr->newSelectQueryBuilder()
52  ->select( '*' )
53  ->from( 'blob_orphans' )
54  ->caller( __METHOD__ )->fetchResultSet();
55 
56  $num = 0;
57  $totalSize = 0;
58  $hashes = [];
59  $maxSize = 0;
60 
61  foreach ( $res as $row ) {
62  $extDB = $this->getExternalDB( DB_REPLICA, $row->bo_cluster );
63  $blobRow = $extDB->newSelectQueryBuilder()
64  ->select( '*' )
65  ->from( 'blobs' )
66  ->where( [ 'blob_id' => $row->bo_blob_id ] )
67  ->caller( __METHOD__ )->fetchRow();
68 
69  $num++;
70  $size = strlen( $blobRow->blob_text );
71  $totalSize += $size;
72  $hashes[sha1( $blobRow->blob_text )] = true;
73  $maxSize = max( $size, $maxSize );
74  }
75  unset( $res );
76 
77  $this->output( "Number of orphans: $num\n" );
78  if ( $num > 0 ) {
79  $this->output( "Average size: " . round( $totalSize / $num, 0 ) . " bytes\n" .
80  "Max size: $maxSize\n" .
81  "Number of unique texts: " . count( $hashes ) . "\n" );
82  }
83  }
84 }
85 
86 $maintClass = OrphanStats::class;
87 require_once RUN_MAINTENANCE_IF_MAIN;
Abstract maintenance class for quickly writing and churning out maintenance scripts with minimal effo...
Definition: Maintenance.php:66
getDB( $db, $groups=[], $dbDomain=false)
Returns a database to be used by current maintenance script.
output( $out, $channel=null)
Throw some output to the user.
getServiceContainer()
Returns the main service container.
addDescription( $text)
Set the description text.
fatalError( $msg, $exitCode=1)
Output a message and terminate the current script.
Maintenance script that shows some statistics on the blob_orphans table, created with trackBlobs....
Definition: orphanStats.php:32
getExternalDB( $db, $cluster)
Definition: orphanStats.php:39
__construct()
Default constructor.
Definition: orphanStats.php:33
execute()
Do the actual work.
Definition: orphanStats.php:46
$maintClass
Definition: orphanStats.php:86
const DB_REPLICA
Definition: defines.php:26