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
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
|
<?php
/**
* Run this script periodically if you have miser mode enabled, to refresh the
* caches
*
* @file
* @ingroup Maintenance
*/
$options = array('only','help');
require_once( 'commandLine.inc' );
require_once( "$IP/includes/SpecialPage.php" );
require_once( "$IP/includes/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";
print " --override : update even pages which have had updates disabled\n";
wfDie();
}
$wgOut->disable();
$dbw = wfGetDB( DB_MASTER );
foreach( $wgSpecialPageCacheUpdates as $special => $call ) {
if( !is_callable($call) ) {
print "Uncallable function $call!\n";
continue;
}
$t1 = explode( ' ', microtime() );
call_user_func( $call, $dbw );
$t2 = explode( ' ', microtime() );
printf( '%-30s ', $special );
$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( "completed in %.2fs\n", $seconds );
# Wait for the slave to catch up
wfWaitForSlaves( 5 );
}
foreach( $wgQueryPages as $page ) {
@list( $class, $special, $limit ) = $page;
# --list : just show the name of pages
if( @$options['list'] ) {
print "$special\n";
continue;
}
if ( !isset( $options['override'] ) && $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 ( !wfGetLB()->pingAll()) {
print "\n";
do {
print "Connection failed, reconnecting in 10 seconds...\n";
sleep(10);
} while ( !wfGetLB()->pingAll() );
print "Reconnected\n\n";
} else {
# Commit the results
$dbw->immediateCommit();
}
# Wait for the slave to catch up
wfWaitForSlaves( 5 );
} else {
print "cheap, skipped\n";
}
}
}
|
