3 require_once( dirname( __FILE__
) . '/commandLine.inc' );
5 function purgeStaleMemcachedText() {
6 global $wgMemc, $wgDBname;
7 $db = wfGetDB( DB_MASTER
);
8 $maxTextId = $db->selectField( 'text', 'max(old_id)' );
9 $latestReplicatedTextId = $db->selectField( array( 'recentchanges', 'revision' ), 'rev_text_id',
10 array( 'rev_id = rc_this_oldid', "rc_timestamp < '20101225183000'"), 'purgeStaleMemcachedText',
11 array( 'ORDER BY' => 'rc_timestamp DESC' ) );
12 $latestReplicatedTextId -= 100; # A bit of paranoia
14 echo "Going to purge text entries from $latestReplicatedTextId to $maxTextId in $wgDBname\n";
16 for ( $i = $latestReplicatedTextId; $i < $maxTextId; $i++
) {
17 $key = wfMemcKey( 'revisiontext', 'textid', $i );
20 if (! $wgMemc->delete( $key ) ) {
21 echo "Memcache delete for $key returned false\n";
23 if ( $wgMemc->get( $key ) ) {
24 echo "There's still content in $key!\n";
33 purgeStaleMemcachedText();