MediaWiki
master
Toggle main menu visibility
storageTypeStats.php
Go to the documentation of this file.
1
<?php
7
8
use
MediaWiki\Maintenance\Maintenance
;
9
10
// @codeCoverageIgnoreStart
11
require_once __DIR__ .
'/../Maintenance.php'
;
12
// @codeCoverageIgnoreEnd
13
14
class
StorageTypeStats
extends
Maintenance
{
15
public
function
execute
() {
16
$dbr = $this->getReplicaDB();
17
18
$endId = $dbr->newSelectQueryBuilder()
19
->select(
'MAX(old_id)'
)
20
->from(
'text'
)
21
->caller( __METHOD__ )->fetchField();
22
if
( !$endId ) {
23
$this->fatalError(
'No text rows!'
);
24
}
25
26
$binSize = intval( 10 ** ( floor( log10( $endId ) ) - 3 ) );
27
if
( $binSize < 100 ) {
28
$binSize = 100;
29
}
30
echo
"Using bin size of $binSize\n"
;
31
32
$stats = [];
33
34
$classSql = <<<SQL
35
IF(old_flags LIKE
'%external%'
,
36
IF(old_text REGEXP
'^DB://[[:alnum:]]+/[0-9]+/[0-9a-f]{32}$'
,
37
'CGZ pointer'
,
38
IF(old_text REGEXP
'^DB://[[:alnum:]]+/[0-9]+/[0-9]{1,6}$'
,
39
'DHB pointer'
,
40
IF(old_text REGEXP
'^DB://[[:alnum:]]+/[0-9]+$'
,
41
'simple pointer'
,
42
'UNKNOWN pointer'
43
)
44
)
45
),
46
IF(old_flags LIKE
'%object%'
,
47
TRIM(
'"'
FROM SUBSTRING_INDEX(SUBSTRING_INDEX(old_text,
':'
, 3),
':'
, -1)),
48
'[none]'
49
)
50
)
51
SQL;
52
53
for
( $rangeStart = 0; $rangeStart < $endId; $rangeStart += $binSize ) {
54
if
( intdiv( $rangeStart, $binSize ) % 10 === 0 ) {
55
echo
"$rangeStart\r"
;
56
}
57
$res = $dbr->newSelectQueryBuilder()
58
->select( [
'old_flags'
,
'class'
=> $classSql,
'count'
=>
'COUNT(*)'
] )
59
->from(
'text'
)
60
->where( $dbr->expr(
'old_id'
,
'>='
, intval( $rangeStart ) ) )
61
->andWhere( $dbr->expr(
'old_id'
,
'<'
, intval( $rangeStart + $binSize ) ) )
62
->groupBy( [
'old_flags'
,
'class'
] )
63
->caller( __METHOD__ )->fetchResultSet();
64
65
foreach
( $res as $row ) {
66
$flags = $row->old_flags;
67
if
( $flags ===
''
) {
68
$flags =
'[none]'
;
69
}
70
$class = $row->class;
71
$count = $row->count;
72
if
( !isset( $stats[$flags][$class] ) ) {
73
$stats[$flags][$class] = [
74
'count'
=> 0,
75
'first'
=> $rangeStart,
76
'last'
=> 0
77
];
78
}
79
$entry =& $stats[$flags][$class];
80
$entry[
'count'
] += $count;
81
$entry[
'last'
] = max( $entry[
'last'
], $rangeStart + $binSize );
82
unset( $entry );
83
}
84
}
85
echo
"\n\n"
;
86
87
$format =
"%-29s %-39s %-19s %-29s\n"
;
88
printf( $format,
"Flags"
,
"Class"
,
"Count"
,
"old_id range"
);
89
echo str_repeat(
'-'
, 120 ) .
"\n"
;
90
foreach
( $stats as $flags => $flagStats ) {
91
foreach
( $flagStats as $class => $entry ) {
92
printf( $format, $flags, $class, $entry[
'count'
],
93
sprintf(
"%-13d - %-13d"
, $entry[
'first'
], $entry[
'last'
] ) );
94
}
95
}
96
}
97
}
98
99
// @codeCoverageIgnoreStart
100
$maintClass
= StorageTypeStats::class;
101
require_once RUN_MAINTENANCE_IF_MAIN;
102
// @codeCoverageIgnoreEnd
$maintClass
$maintClass
Definition
addChangeTag.php:56
StorageTypeStats
Definition
storageTypeStats.php:14
StorageTypeStats\execute
execute()
Definition
storageTypeStats.php:15
MediaWiki\Maintenance
Definition
applyChangeTag.php:11
maintenance
storage
storageTypeStats.php
Generated on
for MediaWiki by
1.18.0