1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
<?php
# Run this script periodically if you have miser mode enabled, to refresh the caches
$options = array('only','help');
require_once( 'commandLine.inc' );
require_once( 'SpecialPage.php' );
require_once( 'QueryPage.php' );
if(@$options['help']) {
print "usage:updateSpecialPages.php [--help] [--only=page]\n";
print " --help : this help message\n";
print " --list : list special pages names\n";
print " --only=page : only update 'page'. Ex: --only=BrokenRedirects\n";
wfDie();
}
$wgOut->disable();
$dbw = wfGetDB( DB_MASTER );
foreach ( $wgQueryPages as $page ) {
@list( $class, $special, $limit ) = $page;
# --list : just show the name of pages
if( @$options['list'] ) {
print "$special\n";
continue;
}
if ( $wgDisableQueryPageUpdate && in_array( $special, $wgDisableQueryPageUpdate ) ) {
printf("%-30s disabled\n", $special);
continue;
}
$specialObj = SpecialPage::getPage( $special );
if ( !$specialObj ) {
print "No such special page: $special\n";
exit;
}
if ( !class_exists( $class ) ) {
$file = $specialObj->getFile();
require_once( $file );
}
$queryPage = new $class;
if( !(isset($options['only'])) or ($options['only'] == $queryPage->getName()) ) {
printf( '%-30s ', $special );
if ( $queryPage->isExpensive() ) {
$t1 = explode( ' ', microtime() );
# Do the query
$num = $queryPage->recache( $limit === null ? $wgQueryCacheLimit : $limit );
$t2 = explode( ' ', microtime() );
if ( $num === false ) {
print "FAILED: database error\n";
} else {
print "got $num rows in ";
$elapsed = ($t2[0] - $t1[0]) + ($t2[1] - $t1[1]);
$hours = intval( $elapsed / 3600 );
$minutes = intval( $elapsed % 3600 / 60 );
$seconds = $elapsed - $hours * 3600 - $minutes * 60;
if ( $hours ) {
print $hours . 'h ';
}
if ( $minutes ) {
print $minutes . 'm ';
}
printf( "%.2fs\n", $seconds );
}
# Reopen any connections that have closed
if ( !$wgLoadBalancer->pingAll()) {
print "\n";
do {
print "Connection failed, reconnecting in 10 seconds...\n";
sleep(10);
} while ( !$wgLoadBalancer->pingAll() );
print "Reconnected\n\n";
} else {
# Commit the results
$dbw->immediateCommit();
}
# Wait for the slave to catch up
/*
$slaveDB = wfGetDB( DB_SLAVE, array('QueryPage::recache', 'vslow' ) );
while( $slaveDB->getLag() > 600 ) {
print "Slave lagged, waiting...\n";
sleep(30);
}
*/
wfWaitForSlaves( 5 );
} else {
print "cheap, skipped\n";
}
}
}
|
