1 files changed, 46 insertions, 0 deletions
diff --git a/maintenance/storage/orphanStats.php b/maintenance/storage/orphanStats.php
new file mode 100644
index 00000000..afea815e
--- /dev/null
+++ b/maintenance/storage/orphanStats.php
@@ -0,0 +1,46 @@
+<?php
+
+/**
+ * Show some statistics on the blob_orphans table, created with trackBlobs.php
+ */
+require_once( dirname(__FILE__).'/../commandLine.inc' );
+
+$stats = new OrphanStats;
+$stats->execute();
+
+class OrphanStats {
+	function getDB( $cluster ) {
+		$lb = wfGetLBFactory()->getExternalLB( $cluster );
+		return $lb->getConnection( DB_SLAVE );
+	}
+
+	function execute() {
+		$extDBs = array();
+		$dbr = wfGetDB( DB_SLAVE );
+		$res = $dbr->select( 'blob_orphans', '*', false, __METHOD__ );
+		
+		$num = 0;
+		$totalSize = 0;
+		$hashes = array();
+		$maxSize = 0;
+
+		foreach ( $res as $boRow ) {
+			$extDB = $this->getDB( $boRow->bo_cluster );
+			$blobRow = $extDB->selectRow( 'blobs', '*', array( 'blob_id' => $boRow->bo_blob_id ), __METHOD__ );
+			
+			$num++;
+			$size = strlen( $blobRow->blob_text );
+			$totalSize += $size;
+			$hashes[ sha1( $blobRow->blob_text ) ] = true;
+			$maxSize = max( $size, $maxSize );
+		}
+		unset( $res );
+
+		echo "Number of orphans: $num\n";
+		if ( $num > 0 ) {
+			echo "Average size: " . round( $totalSize / $num, 0 ) . " bytes\n" .
+			"Max size: $maxSize\n" . 
+			"Number of unique texts: " . count( $hashes ) . "\n";
+		}
+	}
+}